Rounding a result

[Frank Kabel]

Hi
you probably have only changed the format (the display).
To really round use
=ROUND(your_formula,2)

-----Original Message-----
When using the PMT function to calculate a loan payment,

the result I'm getting is a negative number with more than
2 decimal places.

-327.4347167 I am then taking the result, (which I have set to only 2 decimal places)
-327.43 and multiplying it by the numer of payments to

calculate the total of 60 payments.

I'm getting -19,646.08 and it should be -19,645.80 This

result I'm getting seems to be using is using those
numbers that should have been rounded off.

How do I round off the result to a number with 2 decimal

places and use only the rounded number to perform other
calculations?