CODEWITHSUNDEEP
excelindexingmatchvlookup
osomanden
osomanden

Reputation: 611

Excel check for value in different cells per row

Having this kind of data:

    A   B   C   D   E
1   1   0   1   0   0
2   0   1   1   0   1
3   1   0   1   1   0
4   0   1   0   1   0

I would like to show true/false in column F if column A, C and E has the value of 1.

So not looking for a value in range - but different columns.

Upvotes: 0

Views: 43

Answers (2)

Andreas
Andreas

Reputation: 23958

=IF(A2;IF(C2;IF(E2;TRUE;FALSE);FALSE);FALSE)

This will display TRUE if ALL three cells are 1, else FALSE.

Upvotes: 0

FDavidov
FDavidov

Reputation: 3675

You can use the AND function, something like:

=IF(AND(A1=1,C1=1,E1=1),"TRUE","FALSE")

Upvotes: 1

Related Questions