IF Forumla Problem
 

I have this formula,
=IF(G14<=1,0,IF(G14<=2,5,IF(G14<=3,10,IF(G14=4,15 ,0)))) , if the data is 3.5
it returns 0, instead of 10. All other decimals seem to work. Any ideas what
I am doing wrong?
Thanks,

IF Forumla Problem
 

Look at the way your formula is constructed:

1) If less than or equal to 1, then 0
2) If less than or equal to 2, then 5
3) If less than or equal to 3, then 10,
4) If greater than or equal to 4, then 15, else 0

3.5 us greater than 3 but less than 4, therefore, the formula is returning 0.

Dave
--
Brevity is the soul of wit.


"MCook" wrote:

I have this formula,
=IF(G14<=1,0,IF(G14<=2,5,IF(G14<=3,10,IF(G14=4,15 ,0)))) , if the data is 3.5
it returns 0, instead of 10. All other decimals seem to work. Any ideas what
I am doing wrong?
Thanks,

IF Forumla Problem
 

Dave - Thank you, I feel like a dope for not seeing that.
Matt

"Dave F" wrote:

Look at the way your formula is constructed:

1) If less than or equal to 1, then 0
2) If less than or equal to 2, then 5
3) If less than or equal to 3, then 10,
4) If greater than or equal to 4, then 15, else 0

3.5 us greater than 3 but less than 4, therefore, the formula is returning 0.

Dave
--
Brevity is the soul of wit.


"MCook" wrote:

I have this formula,
=IF(G14<=1,0,IF(G14<=2,5,IF(G14<=3,10,IF(G14=4,15 ,0)))) , if the data is 3.5
it returns 0, instead of 10. All other decimals seem to work. Any ideas what
I am doing wrong?
Thanks,