View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Elkar
 
Posts: n/a
Default Weird Arithmetic Error

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?