View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Swordsman Swordsman is offline
external usenet poster
 
Posts: 16
Default Rounding Problem

did you try

=Round((A+B)*1.06,2)

will there be no problem in your accounting sheet if you do so?

"Alfred Kaufmann" wrote:

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