Solved: Recieving a "FALSE" in If function. Need Help!

[mulley13]

The following function, for some reason, will not work with certain numbers:

=IF(AND(Totals!S5>=1,Totals!S5<=1.67),"Minor",IF(AND(Totals!S5>=1.68,Totals !S5<=2.35),"Moderate",IF(AND(Totals!S5>=2.36,Totals!S5<=3),"Severe")))

This is a simple function but when the value in "Totals!S5" is 1.67 or 2.35 it returns a FALSE in the cell. For the life of me I cannot figure out why. Is there anyone who could help me with this. (I know the function may be set up really bad and my lack of knowledge may be the problem). There is never a time when the value should be false because the numbers in "Totals!S5" are always between 1 and 3.

thanks

[mdmackillop]

I think you are returning values rounded down/up eg 1.672.
try
=IF(AND(Totals!S5>=1,Totals!S5<=1.675),"Minor",IF(AND(Totals!S5>1.675,Total s!S5<=2.355),"Moderate",IF(AND(Totals!S5>2.355,Totals!S5<=3),"Severe")))

[mulley13]

Thanks that did the trick.

[geekgirlau]

Welcome to the Board!

Don't forget to mark this thread as solved (click on "Thread Tools" at the top of the page).