View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf MyVeryOwnSelf is offline
external usenet poster
 
Posts: 213
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?


Even if only two decimal places are showing in a cell, the underlying un-
rounded values are used when a formula elsewhere refers to the cell.

After experiencing a lot of annoyance like you have experienced, I decided
to always ROUND() intermediate values in financial calculations like this,
so the underlying value is exactly the displayed value. It saves me time in
the long run.