Excel 2000 autosum not adding correctly

[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?

 

[Anne Troy]

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

 

[Dodo2u]

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?

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.

 

[Ken Wright]

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
------------------------------­------------------------------­----------------