Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |