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

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