Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding dollar amounts up/down when cents aren't part of the fact
Hello!
I am trying to set up a calculation to round dollar amounts up or down. Cents are not included in the calculation and the cells have already been set to not do decimal places. I have gone through the existing rounding posts and found several helpful items that will work with other spreadsheets, but nothing that seems to work with what I need at the moment. Here are some examples: $767,364 x 19.157 = $14,700,392 (need it to round to $14,700) $160,824 x 11.687 = $1,879,550 (need it to round to $1,880) $262,360 x 1.180 = $309,585 (need it to round to $310) If this has been covered before I apologize for not finding it and would greatly appreciate any help that can be given. Thank you in advance! -- PhenyxFire Always five, acting as one. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding dollar amounts up/down when cents aren't part of the fact
Try this:
For values in A1 and B1 C1: =ROUND(A1*B1,-3)*0.001 Using your sample data of 767364 and 19.157, C1 returns 14700 Is that something you can work with? *********** Regards, Ron XL2002, WinXP "PhenyxFire" wrote: Hello! I am trying to set up a calculation to round dollar amounts up or down. Cents are not included in the calculation and the cells have already been set to not do decimal places. I have gone through the existing rounding posts and found several helpful items that will work with other spreadsheets, but nothing that seems to work with what I need at the moment. Here are some examples: $767,364 x 19.157 = $14,700,392 (need it to round to $14,700) $160,824 x 11.687 = $1,879,550 (need it to round to $1,880) $262,360 x 1.180 = $309,585 (need it to round to $310) If this has been covered before I apologize for not finding it and would greatly appreciate any help that can be given. Thank you in advance! -- PhenyxFire Always five, acting as one. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding dollar amounts up/down when cents aren't part of the
That is exactly what I was looking for! I had tried something similar, but
had not done the combination of -3 and 0.001 in the calculation. Thank you so much, Ron, I really appreciate it! -- PhenyxFire Always five, acting as one. "Ron Coderre" wrote: Try this: For values in A1 and B1 C1: =ROUND(A1*B1,-3)*0.001 Using your sample data of 767364 and 19.157, C1 returns 14700 Is that something you can work with? *********** Regards, Ron XL2002, WinXP "PhenyxFire" wrote: Hello! I am trying to set up a calculation to round dollar amounts up or down. Cents are not included in the calculation and the cells have already been set to not do decimal places. I have gone through the existing rounding posts and found several helpful items that will work with other spreadsheets, but nothing that seems to work with what I need at the moment. Here are some examples: $767,364 x 19.157 = $14,700,392 (need it to round to $14,700) $160,824 x 11.687 = $1,879,550 (need it to round to $1,880) $262,360 x 1.180 = $309,585 (need it to round to $310) If this has been covered before I apologize for not finding it and would greatly appreciate any help that can be given. Thank you in advance! -- PhenyxFire Always five, acting as one. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding dollar amounts up/down when cents aren't part of the
You're very welcome. Thanks for letting me know that worked for you.
*********** Regards, Ron XL2002, WinXP "PhenyxFire" wrote: That is exactly what I was looking for! I had tried something similar, but had not done the combination of -3 and 0.001 in the calculation. Thank you so much, Ron, I really appreciate it! -- PhenyxFire Always five, acting as one. "Ron Coderre" wrote: Try this: For values in A1 and B1 C1: =ROUND(A1*B1,-3)*0.001 Using your sample data of 767364 and 19.157, C1 returns 14700 Is that something you can work with? *********** Regards, Ron XL2002, WinXP "PhenyxFire" wrote: Hello! I am trying to set up a calculation to round dollar amounts up or down. Cents are not included in the calculation and the cells have already been set to not do decimal places. I have gone through the existing rounding posts and found several helpful items that will work with other spreadsheets, but nothing that seems to work with what I need at the moment. Here are some examples: $767,364 x 19.157 = $14,700,392 (need it to round to $14,700) $160,824 x 11.687 = $1,879,550 (need it to round to $1,880) $262,360 x 1.180 = $309,585 (need it to round to $310) If this has been covered before I apologize for not finding it and would greatly appreciate any help that can be given. Thank you in advance! -- PhenyxFire Always five, acting as one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL HAS STARTED ROUNDING TO THE WHOLE DOLLAR | Excel Discussion (Misc queries) | |||
Rounding to nearest 5 cents in excel | Excel Worksheet Functions | |||
What is the formula for rounding a dollar amount to the nearest ni | New Users to Excel | |||
ROUND CENTS TO EITHER 49 OR 99 AMOUNTS | Excel Worksheet Functions | |||
rounding to nearest hundred dollar in Excel | New Users to Excel |