divide and round up

[Pammy]

I have a formula: c5/4
I want a formula to divide: c5/4 then round up to a whole number. example:

if the answer is 17.3 I want the answer to be 18.

[Jim Thomlinson]

=roundup(c5/4, 0)
--
HTH...

Jim Thomlinson

Post by Pammy
I have a formula: c5/4
if the answer is 17.3 I want the answer to be 18.

[Matt Lehodey]

Do you know how I would make the answer show as a %?

[Eduardo]

Hi,
=roundup(c5/4,0)

Post by Pammy
I have a formula: c5/4
if the answer is 17.3 I want the answer to be 18.

[h***@gmail.com]

Post by Pammy
I have a formula: c5/4
if the answer is 17.3 I want the answer to be 18.

What if I want to divide cell D5 by cell B4 and then roundup?

[colglbo]

Post by h***@gmail.com

Post by Pammy
I have a formula: c5/4
if the answer is 17.3 I want the answer to be 18.

What if I want to divide cell D5 by cell B4 and then roundup?

=INT(C5/4)+1

[colglbo]

Post by colglbo

Post by h***@gmail.com

Post by Pammy
I have a formula: c5/4
if the answer is 17.3 I want the answer to be 18.

What if I want to divide cell D5 by cell B4 and then roundup?

=INT(C5/4)+1

Didn't read question correctly

=INT(D5/B4)+1

[d***@gmail.com]

Post by colglbo
=INT(D5/B4)+1

That wouldn't work if the result of the division is a whole number it would round up when it shouldn't


roundup is the one you'd want to use

[h***@gmail.com]

Post by Pammy
I have a formula: c5/4
if the answer is 17.3 I want the answer to be 18.

Very cool thanks! I also got it to work with =ROUNDUP(D5/B4,0) :)

[zvkmpw]

Post by h***@gmail.com

Post by Pammy
I have a formula: c5/4
I want a formula to divide: c5/4 then round up to a whole number.
if the answer is 17.3 I want the answer to be 18.

Very cool thanks! I also got it to work with =ROUNDUP(D5/B4,0) :)

The ROUNDUP() approach is better. For example, if D5 and B4 happen contain the same number, the desired result is probably 1, not 2.

[Vijay Anand. G]

i need a formula: 9.77/2 = 4.885, but i need for 4.88