IF Forumla Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hlookup in array 2
IF-more than 7 arguments 3
Greater than less than arguement returning value when text inputte 2
Returning a value rather than TRUE or FALSE. 3
Format a field in an equation 4
If statement problem 2
complex IF formula returns #VALUE! 1
Execute a statement if certain criteria is met 2

Back
Top