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

=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

Look at ROUND( ) in Excel help.

--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott


"Urgent" wrote:

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

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

Hi,

If you are really looking at one cell as in your formula:

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

Then change this to read

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

and drop the SUM

If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Urgent" wrote:

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