why are my worksheet autosum totals one cent off?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

allan - 19 May 2008 19:01 GMT

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?

Reply to this Message

T. Valko - 19 May 2008 19:11 GMT

See this:

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

Signature

Biff
Microsoft Excel MVP

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

Reply to this Message

Jim Cone - 19 May 2008 19:22 GMT

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" <allan@discussions.microsoft.com>
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?

Reply to this Message