Excel Formula

[Bu77al0]

I am trying to enter a formual using the IF function. For example:
=+IF(D26=0%,0.49%,"1",IF( D26=0.50%,1.90%,"2"))

In other words, I am trying to attain a value if the cell falls within a range of numbers. In the above example, the range would be from 0% to .49% or .50% to 1.90%.

How do I enter the range of numbers?

Thank you
This message was edited by Bu77al0 on 2002-11-06 18:23
This message was edited by Bu77al0 on 2002-11-06 18:24

 

[phantom1975]

WELCOME TO THE BOARD!

Try this instead:

=IF(D26<.005,1,if(D26<.019,2,""))

Did that work for you?

 

[Aladin Akyurek]

Try to expand the following for your larger set...

=INDEX({1;2},MATCH(D26,{0;0.005}))

 

[Bu77al0]

Thank you very much! Problem solved