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

What if A1 is between 3% and 3.9%?

"TRYIN" wrote in message
...
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

I'll bet this is what you really meant:

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

=IF(A12.9%,150,IF(A1=2%,100,IF(A1=1%,50,0)))

--
Biff
Microsoft Excel MVP


"TRYIN" wrote in message
...
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

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


"TRYIN" wrote in message
...
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

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)

"TRYIN" wrote in message
...
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