|
|
See
http://www.mcgimpsey.com/excel/pennyoff.html
In article ,
Overlanda wrote:
Put this into a cell and change the format of the cell to number with 16
decimal places...
=1131.97-1123
The answer is 8.9700000000000300
Notice the 3 at the 14th place after the decimal.
Haha what a joke.
I have tried on two Excel 2003 boxes - one with SP1 and one without. Both
calculated it incorrectly
|