adding money amounts in excel
 

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.

adding money amounts in excel
 

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



"Holden Caulfield" wrote in
message ...
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.