View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default Rounding Problem

Look at:

http://www.cpearson.com/excel/rounding.htm

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Alfred Kaufmann" wrote in message
...
I have got a very simple accounting spreadsheet where column C is
determined by (A+B)*1.06. Cell C is formatted for dollars - two
decimal places. At the bottom of column C is a total which is usually
correct but sometimes it is out by one cent. All the calculations
across are correct. I am sure there is an easy way to fix this isn't
there? Thanks.

Al