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?
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?
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" <[email protected]> wrote in
message news:[email protected]...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks