INT Function not working

[ssalazarjr]

I'm getting a FALSE when entering this formula.

A2=$789.14
B2=$ 3.14

=(A2-INT(A2))=(B2-INT(B2))

When I evaluate the formula I get notice:

=(.1399999999986)=(B2-INT(B2))

=(.1399999999986)=(.14)

I've know its not a decimal place issue, because I'm entering the amounts myself. I put exactly 789.14.

I also tried =MOD(A2,1)=MOD(B2,1) and it does the same thing.

 

[MrKowz]

It has to do with the floating point decimal system that Excel uses. A way around it is to use the ROUND function as well... try:

=ROUND((A2-INT(A2)),2)=ROUND((B2-INT(B2)),2)

 

[ssalazarjr]

Hey thanks for your reply.

I googled the "floating point decimal system" (thanks to your reply) and found their is a way to deactivate it.

1. Click Microsoft Office Button -> Excel Options -> Advanced
2. Scroll down to "When calculating this workbook" section
3. Check "Set precision as displayed"

Do see any problems with doing it that way?

 

[MrKowz]

If you have any calculations that need to be more accurate, then unticking that option can cause things to go awry.

 

[ssalazarjr]

I'll just add the ROUND function, as you suggested, just to be safe.

Thanks for you help!