ssalazarjr
Board Regular
- Joined
- Jun 1, 2009
- Messages
- 158
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.
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.