IF STATEMENT

[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

 

[Gaurav]

What if A1 is between 3% and 3.9%?

 

[T. Valko]

I'll bet this is what you really meant:

=1% but <=1.9% = 50
=2% but <=2.9% = 100
2.9% = 150

=IF(A1>2.9%,150,IF(A1>=2%,100,IF(A1>=1%,50,0)))

 

[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.

 

[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)