SUM calculation bug in Excel 2003?

  • Thread starter SUM calculation bug in Excel 2003?
  • Start date
S

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
 
B

bpeltzer

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)
 
T

Toppers

If the value of your sum is (for example) 93.5 it will show as 94 if you are
not displaying any decimal places but 93.5*200 =18700.

There is a difference between what is displayed and what is actual held as
the internal number.

Format your cells to display 2 (or more) decimal places and see the results.

HTH
 
D

David Biddulph

"SUM calculation bug in Excel 2003?" <SUM calculation bug in Excel
[email protected]> wrote in message
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
Click to expand...

Is the sum really 94? What happens if you reformat the cell to show more
decimal places? I guess it says 93.5?

If you really do want to round the number before you multiply by 20, you can
either do =ROUND(SUM(B81:B125),0) or =ROUND(M124,0)*200
 
Top