Excel 2000 autosum not adding correctly

  • Thread starter Thread starter ProdigyNews
  • Start date Start date
P

ProdigyNews

I use Excel 2000 and have been for some time. Today I placed dollar
amounts in a column and then hit autosum. I was given a total of $5887.70.
I then added the last numbers in my head and also a calculator and the total
was $5887.71, off by 1 on the last digit. I tried numerous times getting
the same results. All of the cells have been formatted for currency with 2
decimal points. Does anyone have an explanation?
 
Sure. What are the ACTUAL values in the cells? If you've got values like
123.456, these are rounding up. Instead of using formatting to round the
cells, round them using formulas:
=round(a1*b1,2)
That'll round the result of a1*b1 to 2 decimals.
*******************
~Anne Troy

www.OfficeArticles.com
 
I use Excel 2000 and have been for some time. Today I placed dollar
amounts in a column and then hit autosum. I was given a total of
$5887.70. I then added the last numbers in my head and also a
calculator and the total was $5887.71, off by 1 on the last digit. I
tried numerous times getting the same results. All of the cells have
been formatted for currency with 2 decimal points. Does anyone have an
explanation?
Click to expand...

Even when limiting the number of decimals in a cell, Excel remembers and
uses more decimals for/after calculations.
So the fractions not shown might cause differences between Excel and human
calculation results.
 
Simply formatting does NOT change the underlying numbers:-

http://www.mcgimpsey.com/excel/pennyoff.html

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
Back
Top