IF, THEN formulas
 

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.

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

www.OfficeArticles.com
www.MyExpertsOnline.com


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

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

"Anne Troy" wrote:

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

www.OfficeArticles.com
www.MyExpertsOnline.com


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