Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rounding decimal places | Excel Discussion (Misc queries) | |||
Rounding up for a decimal | Excel Worksheet Functions | |||
Rounding to two even decimal places | Excel Worksheet Functions | |||
Decimal Place Rounding | Excel Worksheet Functions | |||
Rounding decimal | Excel Worksheet Functions |