excel 2007 auto sum does not add correctly

  • Thread starter Thread starter Lois
  • Start date Start date
L

Lois

I am using Excel 2007 and when using 'auto sum' the calculation does not add
correctly - it is a couple of cents out. I have 2 decimal places
 
It is likely not an error. I'm guessing that your numbers are the results of
formulas. And that you've got those results formatted to display 2 decimal
places.

For example, your formula results in 10.284, but your display shows 10.28.
The cell still contains 10.284 even though .004 appears to have been rounded
off. The SUM function uses the actual value of the cells (10.284) not the
displayed value (10.28). So, it appears that the SUM is off by a few cents,
but it really isn't.

If you truly want to round your numbers off to 2 decimal places, use the
ROUND function instead of cell formatting. Cell formatting only affects what
is displayed, not the actual number.

HTH
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM does not work in Excel 2007 3
(0.00) 1
Pivot Table Calculation Error 1
Excel How to add numbers in same cell? 2
Access stripping decimal places in query 1
Rounding cents 3
Rounding problem or sum function not working correctly 2
Suming 2 values with oposite sign, the sum is not 0. but an E val 3

Back
Top