Hi

I've got this spreadsheet which is baisically doing some simple number crunching but for some unbeknown reason i keep getting a flase value for for a couple of results? I'm not sure why because a majority of the results are coming back correct its literally just certain boxes, and their is no logical relationship between the boxes that return false.

Rite so I have 6 columns filled with numbers. In the seventh column im getting percentages of these columns using the formula:

(numbers are just for demonstration)

=C17/F17*100


Then a couple of columns along i've want it so that if this formula above equates to:
>75 = 1
>90 = 2
>100 = 3
<=100 = 4

so the code is
G17 being the box that contains the code above!

=IF(G17<=74,1,IF(G17<=89,2,IF(G17=99,3,IF(G17>=100,4))))


As i have said this works for most of my results except for a few which seem to pull a false value out of nowhere.

And just so you know the first formula is returning the correct number, in this case it was 100!

Anyhelp is much appreciated!

Should it be:


if(G17<75,1,if(G17<90,2,if (G17 <100,3,if(g17>=100,4))))

ah i found the problem cheers chergh, the actual answer of the box was returning as 99.64XXXXXX where excel was rounding to the nearest whole number! thus the way I did the formula left 99-100 a void number hence the false i was receiving.

Job done!