How do I apply the ROUNDUP formula to a range of calculated data

I

IslandGreenHouse

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?
 
S

Sandy Mann

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top