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" <(E-Mail Removed)> wrote in message
news:4E49365D-C9E5-4DD5-B4B9-(E-Mail Removed)...
> 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
>