If you format your results cell as a Number, then your answer should look
right. I could try to explain why this is, but the following article will do
a much better job:
http://cpearson.com/excel/rounding.htm
HTH,
Elkar
"Keith" wrote:
Can someone please explain the following weird arithmetic error?
enter the amount -2002.08 in cell A1. Enter the amount 83.42 in cells
A2-A25. In cell A26 calculate the sum of cells A1-A25. The answer should be
0. Instead I get 7.10543E-13.
Any clues?