U
Urgent
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
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