Problem IF statement

[Beans]

Simple IF Statement is not working.

A1: 2015.52

B1: =IF(A1-INT(A1)=0.52, "TRUE", "FALSE")........ The result on my sheet is FALSE.....WTF

Any ideas????????

 

[Scott T]

The calculation is returning 0.519999999999982 and that is not = to .52. you can add a round so that it works

=IF(ROUND(A1-INT(A1),2)=0.52, "TRUE", "FALSE")

this is caused by the floating point error see link below

https://support.microsoft.com/en-us...-rounding-errors-in-floating-point-arithmetic

 

[Beans]

Wow, who knew........

Thanks
Glenn