Excel 2007 : Calculation issue?

Hello,

I have a funny calculation issue using Excel 2007.

I have the following values in on my column A starting in row 1:
0.0100
0.0002
0.0100
Now when I add row 1 and 2 and subtract row 3, the result is 0.000200000000000001,
i.e. there is a 1 on the 18th decimal. Is this a known issue?
Thanks for helping!

Check values in A1, A2 and A3. probably those a bigger numbers but only 4 digits shown.

Yes, it is a common problem in all computers in that use floating point arithmetic, it is difficult to be precise in representing decimal numbers when you only have a binary engine. Take a look at http://support.microsoft.com/kb/42980

Interesting. The numbers were typed in as above. And the formula =A1+A2-A3=A2 is giving me FALSE as a result.

See what this returns

=A1+A2-A3-A2

Yes, really interesting... It state TRUE for 1, 0.1, 0.01 but FALSE for 0,001 and lower (in A2)

Originally Posted by Bob Phillips

See what this returns

=A1+A2-A3-A2

It's 0.000000000000000001 so the same difference.