View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tnolen tnolen is offline
external usenet poster
 
Posts: 1
Default incorrect calculations

I have created a worksheet with 4 columns...Price per visit, Tax rate, Tax
amount and Total amount. I have set up the formulas to calculate Tax Amount
and Total Amount. Those columns are formatted for currency. When I total the
tax amount column, it come up 2 cents off. Wouldn't the summing of that
column only add by the 2 decimals that it is displaying?