Got a tricky error in my Excel (2004 for Mac, Version 11.2 (050714)
The difference between the two figures:
a1 6833.40
a2 6828.66
Important note: both figures were manually entered exactly as above, no
further (hidden) digits.
Is correctly calculated by Excel as 4.74 in cell a3. So far, so good.
However, when increasing the number of digits for a3 to the max of 30, then
Excel returns the result:
4.739999999999780000000000000000,
Why is this?
Thanks, Michel
Niek Otten - 07 Jan 2006 13:08 GMT
Hi Michel,
See
http://support.microsoft.com/kb/78113

Signature
Kind regards,
Niek Otten
> Got a tricky error in my Excel (2004 for Mac, Version 11.2 (050714)
>
[quoted text clipped - 17 lines]
>
> Thanks, Michel
Michel Finschi - 07 Jan 2006 16:18 GMT
Excellent, thanks Niek.
in Beitrag Ofnl$t4EGHA.2040@TK2MSFTNGP14.phx.gbl schrieb Niek Otten unter
nicolaus@xs4all.nl am 7.1.2006 14:08 Uhr:
> Hi Michel,
>
> See
>
> http://support.microsoft.com/kb/78113