multi level IF statement

Joined
Feb 24, 2009
Messages
1
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB If statement Help 0
IF (ISNUMBER formula with a Range 1
IF Statement, Ranges and SUM 2
Average problem 1
If B1=Level 1 then B2=10 3
VBA Loop If statement 4
If statement for a range of cells 3
IF statement 2

Top