Sums Incorrect

[piginabush]

Hi All,

When entering a simple formula to check if two cells are correct, the basic answer is yes but the helper cell designed says no;

6.84
6.69

Difference=0.15

7.24
7.09

Difference=0.15

However, helper cell states incorrect and and when expanded to 20 decimal places answer shows difference between the two 0.15 sums to be 0.00000000000000088818

Why??

Cheers

 

[Jonmo1]

Floating point precision..

http://support.microsoft.com/kb/78113

Most common solution is to use the ROUND function in your formulas

=ROUND(A1-B1,2)

 

[piginabush]

Excellent Jonmo1, Thank You.