Hi,
i am wondering how to compare a range to a single value
like...
1
--|------
A | 10
B | 20
C | 30
D | 40
E | 50
=if (A1:E1 = 20, true,false)
but true result comes only when the formula is pasted in the B2 cell. wonderig if the whole range can be equated with each cell value like a For Loop.
This will help me avoid multi level IF statement.
Thanks a bunch.
i am wondering how to compare a range to a single value
like...
1
--|------
A | 10
B | 20
C | 30
D | 40
E | 50
=if (A1:E1 = 20, true,false)
but true result comes only when the formula is pasted in the B2 cell. wonderig if the whole range can be equated with each cell value like a For Loop.
This will help me avoid multi level IF statement.
Thanks a bunch.