=ROUND(SUM('[Pension.xls]Sheet1'!$C$9*0.09),2)

--


Regards,


Peo Sjoblom

"Urgent" wrote in message
...
I'm having a rounding problem with my spreadsheet.

Spreadsheet A - info is enter

1,920.00
2,547.69

The amounts above are linked to Spreadsheet B, there I have the amounts
being multiplied by .09.

1,920 x .09 = 172.80 (this works great b/c I only want 2 decimal places)
2,547.69 x .09 = 229.2921 (this doesn't work, it throws my end numbers out
of wack)

How do I fix it so the bottom one rounds to only two places?? My formula
looks like this =SUM('[Pension.xls]Sheet1'!$C$9*0.09)

Thank you for your help.

Carrie