I have a simple formula in e2:

"=+a2+b2+c2+d2" or "=sum(a2:d2)"

The format has 20 decimal places and values are as follows:

a2 = -2048.01
b2 = 1
c2 = 2048.02
d2 = -1
e2 (the result of the formula) = 0.00999999999976353

I have played with this quite a bit. It appears that if you add a positive
and a negative number with a decimal and the result is within 100+/-, you
start getting the calculation error. I have tried this on XP, Vista and
Windows 7.

So, this works:

(2048.01) + 1948.01 = 100

but

(2048.01) + 1949.01 = -99.0000000000002

This is really bad for all accountants trying to balance a work sheet.

Does anyone know if there is already a patch for SP2?


Tim