why are my worksheet autosum totals one cent off?

[allan]

On more than one occasion, I have used autosum to add up a column of numbers
and the sum is one cent off. I double check the answer with a calculator so
I'm sure of the problem. Is there anyone who has encountered this problem?

 

[T. Valko]

See this:

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

 

[Jim Cone]

More details than you probably wanted...
http://support.microsoft.com/kb/78113/en-us
Floating-point arithmetic may give inaccurate results in Excel
--
Also, don't round numbers until you get to the grand total.
'--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"allan" <[email protected]>
wrote in message
On more than one occasion, I have used autosum to add up a column of numbers
and the sum is one cent off. I double check the answer with a calculator so
I'm sure of the problem. Is there anyone who has encountered this problem?