View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Kassie Kassie is offline
external usenet poster
 
Posts: 37
Default 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.