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" <HoldenCaulfield[ at ]discussions.microsoft.com> wrote in
message news:FA4BF91A-B84A-4C9E-A445-F56227EBCEAA[ at ]microsoft.com...
[Quoted Text] >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.
|