View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Rounding Problem

Check this link of John McGimpsey:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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