Formula to change number upwards.

[Guest]

I have a formula in a cell (F17) that calculates the following: =B14/36

Easy enough, it's just a normal formula. However, I would like the result to
come out a bit different. Let's say that B14 = 300. That would (without
decimals) give the answer 8 in cell F17. With decimals, it's 8,33, and this
is where my problem comes in. See, I want the formula in F17 to display the
next "whole" number if the answer is bigger than ,00. Like this:

300/36=8,33 but I want it to display 9. Same if the answer was 20,6 I would
like it to display 21 instead.

Do you understand and does anyone have a good solution?

Thanks,
Svensson

 

[Guest]

use the round function: =ROUND(B14/36,0)

 

[Steve Yandl]

=ROUNDUP(B14/36,0)

Steve

 

[Guest]

Thanks but it does not work. I get the "You've entered too few arguments for
this formula" error. Any other ideas?

 

[Bob Phillips]

=ROUNDUP(B14/36;0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

That's the one, Bob. Thanks a bunch.

=ROUNDUP(B14/36;0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)