autosum addition error
 

when using autosum to add approx 30 cells of simple dollar amounts, it
calculates the total = a few cents short than the real amount- I can use a
calulator to get the correct amount. ie: example of amounts: 20,342.12 +
10,432.24 + 43,215.34 etc. thanks.

autosum addition error
 

Change the format and set the number of decimal places to more than two...
you may have more significant digits and what you see might be after rounding.

If you enter only two decimals then sum will always return the right result...

"Will123" wrote:

when using autosum to add approx 30 cells of simple dollar amounts, it
calculates the total = a few cents short than the real amount- I can use a
calulator to get the correct amount. ie: example of amounts: 20,342.12 +
10,432.24 + 43,215.34 etc. thanks.

autosum addition error
 

Rounding being missing from the original 30 cells is the culprit. This
happens a lot. Whatever formulas are in those 30 cells to create
values, wrap then in a ROUND formula so the value you SEE in the cell is
stripped of any data past the first two digits.

Then you can sum those cells with no problems.

Example:

=A1/B2*C3 might equal 1,234.54789
Displays as 1,234.55, but the .00789 is still there.

Make the formula =ROUND(A1/B2*C3,2) instead, and the result is 1,234.55
for real.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=47831

autosum addition error
 

Hi,

If your numbers a calculated (formula) then the problem may be:

Computers work in binary, we work in decimals

Here is everything you need to know about this issue (and more):

http://support.microsoft.com/kb/78113/en-us
http://support.microsoft.com/kb/42980
http://support.microsoft.com/kb/214118
http://www.cpearson.com/excel/rounding.htm
http://docs.sun.com/source/806-3568/ncg_goldberg.html

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Will123" wrote:

when using autosum to add approx 30 cells of simple dollar amounts, it
calculates the total = a few cents short than the real amount- I can use a
calulator to get the correct amount. ie: example of amounts: 20,342.12 +
10,432.24 + 43,215.34 etc. thanks.