IF STATEMENT

T

TRYIN

I NEED HELP WITH THE FOLLOWING IF STATEMENT:
IF A1 IS BETWEEN 1% AND 1.9% =50
IF A1 IS BETWEEN 2% AND 2.9% =100
IF A1 IS 4% OR MORE =150
 
G

Gaurav

=IF(AND(A1>=0.01,A1<=0.019),50,IF(AND(A1>=0.02,A1<=0.03),100,IF(A1>=0.04,150,"")))

add the condition for 3%-3.9% and turn off the caps lock if posting back.
 
R

Ron Coderre

Not sure about your ranges, but....

Try this:
=LOOKUP(A1*100,{0,1,2,3},{0,50,100,150})

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Top