Rounding

[edver]

Hello,

I'm trying to create a formula for rounding up whole
numbers to the next highest number.

Example, 5/2 would round up to 3. 7/2 would round up to
4, 21/10 = 11 etc.

Any suggestions?

Cookie for the first right answer

Thanks & Cheers

 

[Frank Kabel]

Hi
use
=ROUNDUP(5/2,0)

 

[Bob Phillips]

Edver,

5/2 is not a whole number, it is a fraction.

What should 5/4 round to, up or down?

 

[NHarkawat]

=ceiling(a1,1) will always round up to the next whole number up.