If statement

[ekhawaja]

Looking for an if statement to check 5 column for value of "1", and if ALL have 1, return "1", otherwise "0"

 

[Fluff]

Another option

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1
2	1		1		1		1		1		1
3	1		1		0		1		1		0
4	1				0		1		1		0
Data

Cell Formulas
Range	Formula
K2:K4	K2	=IF(SUM(CHOOSECOLS(A2:I2,SEQUENCE(,5,1,2)))=5,1,0)

 

[ekhawaja]

Then either option in columns L or M should do what you are after. If not, let us know.

I only want to validate values in col A,C,E,G,I etc.......if they contain 1, i want result to show 1, otherwise 0.....they are specific columns....

 

[dreid1011]

I only want to validate values in col A,C,E,G,I etc.......if they contain 1, i want result to show 1, otherwise 0.....they are specific columns....

And do the offered solutions NOT do just that? I am confused, both mine and Fluff's suggested formulas are only looking at those columns you mentioned.

 

[ekhawaja]

Another option

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1
2	1		1		1		1		1		1
3	1		1		0		1		1		0
4	1				0		1		1		0
Data

Cell Formulas
Range	Formula
K2:K4	K2	=IF(SUM(CHOOSECOLS(A2:I2,SEQUENCE(,5,1,2)))=5,1,0)

i think this works, this formula is only looking at every other column?

And do the offered solutions NOT do just that? I am confused, both mine and Fluff's suggested formulas are only looking at those columns you mentioned.

when i choose A2:I2 in the formula, is it not looking at column B ( i don't want to validate B)..

 

[dreid1011]

i think this works, this formula is only looking at every other column?

when i choose A2:I2 in the formula, is it not looking at column B ( i don't want to validate B)..

No, it is not looking at column B. the "SEQUENCE(1,5,1,2)" portion of each of our formulas is telling it to look at every other column starting with column A.

 

[ekhawaja]

No, it is not looking at column B. the "SEQUENCE(1,5,1,2)" portion of each of our formulas is telling it to look at every other column starting with column A.

yes, it is working, i just did a check......thank you so much! @Fluff @dreid1011

 

[Fluff]

Glad we could help & thanks for the feedback.