Rounding Issue

[alex57]

This question uses the IF() and ROUND() functions - both very simple.

Please Login or Register  to view this content.

Basically cell C16 contains the value 1.002 formatted to number. In that case the answer would be "Small". If changed to 1.001, it would no longer equal 0.002 and so it would be large. This works.

However if I change C16 to any other number eg 3.002 nothing seems to work correctly. The evaluation of

Please Login or Register  to view this content.

comes out as something like 0.00029983837373 even though what it should be doing is just: 3.002-3=0.002

can anyone follow or even help?

thanks in advance

[oldchippy]

Hi,

Your formula ROUND(C16,0)=0.002 give an answer of FALSE, thats why its not working. Try this,

=IF(C16-ROUND(C16,0)<=0.002,"Small","Large")