View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default why are my worksheet autosum totals one cent off?


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