ROUNDUP vs CEILING

[Rebecca_SUNY]

Could someone explain the difference between ROUNDUP and CEILING?

 

[ShaneDevenshire]

Hi,

ROUNDUP round up to a certain number of decimal places just like round but
away from 0.
CEILING is like MROUND you control the factor that is controlling the
rounding.

For example

ROUNDUP(1.24,1) =1.3
CEILING(1.24,1) = 2 since you are saying 1 is your unit of rounding, not
how may digits.
CEILING(1.24,.1) = 1.3 since you are saying do the roundup at the tenth.
ROUNDUP(1.24,.1) technically makes no sense so Excel uses 0 instead of .1
and returns 2.

 

[Bob Phillips]

There is none, CEILING is just a touch more intuitive IMO. For instance

=CEILING(0.621,0.25)

is clearer than

=ROUNDUP(0.621/0.25,0)*0.25

In other words, ROUNDUP needs a few more hoops to go through with
non-integers

 

[John C]

ROUNDUP only uses significant digits.
=ROUNDUP(4.231,2) would be 4.24
whereas CEILING allows rounding up to a nearest multiple
=CEILING(4.231,0.05) would be 4.25

 

[John C]

Well
=ROUNDUP(16.621,2)
is much clearer than
=CEILING(16.621,0.01)
IMO.

 

[Bob Phillips]

Shorter, more succinct, yes. But clearer? I don't think so. Where is it
intuitive that the ,2 is going to 2 dec places, whereas the CEILING clearly
shows you the increment.

 

[John C]

It is what is taught in math class. Rounding to x number of decimal places.
So ingrained in me from all those many years ago. Don't get me wrong, I will
use either with ease and regularity, I just think the 2 decimal places is
clearer because that was how it was taught.