Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I apply the ROUNDUP formula to a range of calculated data
I have developed a number of calculations returning values to 2 decimal
points. I want to have those values rounded up to the next whole number. Is there a method to apply the ROUNDUP function to the whole range of values I want to adjust? |
#2
|
|||
|
|||
Wrap the formula in a ROUNDUP formula as in =ROUNDUP(Yourformula,0)
Note: "Yourformula" in this case does not start with an equals sign. However, if by " apply the ROUNDUP function to the whole range of values" you mean to the total of the column then =ROUNDUP(SUM(YourRange,0) may be what you are seeking ie: With the values worked out by the original formulas as: 1.2 1.2 1.5 2.5 then rounding each individual answer will give: 2 2 2 3 SUM: 9 but rounding only the total will give: 1.2 1.2 1.5 2.5 =6.4 rounded up to give 7 Take your pick. HTH Sandy "IslandGreenHouse" wrote in message ... I have developed a number of calculations returning values to 2 decimal points. I want to have those values rounded up to the next whole number. Is there a method to apply the ROUNDUP function to the whole range of values I want to adjust? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If formula for date range | Excel Discussion (Misc queries) | |||
formula to copy last positive number in range of cells | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions | |||
How to populate formula in range of vertical cells to next colum | Excel Worksheet Functions |