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.