IF, THEN formulas

[Guest]

I need a formula that will give me an IF, THEN answer. This is what I need:
If the value in A1 is less than 1.99, then the number 0 would be in A2, If
the value in A1 is between 2 and 4.99, then .5 would be in A2, If the value
in A1 is greater than 5 then the number 1 would be in A2.

 

[Anne Troy]

Hi, KHart. Try this: =IF(A1<=1.99,0,IF(A1<=4.99,.5,1))
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Guest]

Thanks Anne, that was exactly what I needed. I appreciate your prompt reply.
Kathy