View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 180
Default SUM calculation bug in Excel 2003?

More likely, the '94' is really 93.5, but displayed as 94 because of the
format. To check, click in the cell with the 94 and change the format to
show a couple of decimal places (click on the comma style button or format
cells, select the number tab and choose the number of decimal places).
If you indeed now see 93.5, but want that number rounded, and the rounded
number used in subsequent calculations, change =sum(...) to =round(sum(...),0)

"SUM calculation bug in Excel 2003?" wrote:

I sum numbers in one cell =SUM(B81:B125) and the result is 94 (with no error
flag). In the next cell I use the results of the cell to calculate a product
=M124*200 and the result displayed is 18,700 which is wrong. The result
should be 18,800.

94 18,700