adding money amounts in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a formula to calculate 10% of an amount which is rounded off to 2
decimal places. The amount is $1,952.48 and it is rounded off to $195.25
which is what I want it to do. The problem I am encountering is when I click
on the cell the actual value of the number is 195.248. When I add 10 amounts
of the value 195.25 it is calculated to be 1952.48, which is not correct.
The correct sum should be 1952.50. when I copy and paste these values to a
different spread sheet, it is copying 195.248. How do I copy and paste the
195.25 amount? I hope this makes sense to someone because I'm not sure I am
being clear about my problem.
 
You say you are rounding, but clearly you are not rounding. What you did is
to format the cell to show 2 decimal places. =ROUND(<your formula here>),2)
will round to 2 decimal points
Kassie
 
Back
Top