Could someone explain the difference between ROUNDUP and CEILING?

Difference between ROUNDUP and CEILING in Microsoft Excel

ROUNDUP rounds a number up to a specified number of decimal places. For example, if you have the number 3.14159 and you want to round it up to two decimal places, you would use the formula =ROUNDUP(3.14159, 2), which would return 3.15. If the number you are rounding is already at or above the halfway point between two possible rounding values, ROUNDUP will always round up to the higher value.

CEILING rounds a number up to the nearest multiple of a specified number. For example, if you have the number 15 and you want to round it up to the nearest multiple of 5, you would use the formula =CEILING(15, 5), which would return 15. If the number you are rounding is already a multiple of the specified number, CEILING will return that number.

1. ROUNDUP rounds a number up to a specified number of decimal places.
2. CEILING rounds a number up to the nearest multiple of a specified number.

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.


--
Thanks,
Shane Devenshire


"Rebecca_SUNY" wrote:

Could someone explain the difference between ROUNDUP and CEILING?

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

--
__________________________________
HTH

Bob

"Rebecca_SUNY" wrote in message
...
Could someone explain the difference between ROUNDUP and CEILING?

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 **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Rebecca_SUNY" wrote:

Could someone explain the difference between ROUNDUP and CEILING?

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

"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"Rebecca_SUNY" wrote in message
...
Could someone explain the difference between ROUNDUP and CEILING?

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.

--
__________________________________
HTH

Bob

"John C" <johnc@stateofdenial wrote in message
...
Well
=ROUNDUP(16.621,2)
is much clearer than
=CEILING(16.621,0.01)
IMO.
--
** John C **

"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"Rebecca_SUNY" wrote in message
...
Could someone explain the difference between ROUNDUP and CEILING?

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.
--
** John C **

"Bob Phillips" wrote:

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.

--
__________________________________
HTH

Bob

"John C" <johnc@stateofdenial wrote in message
...
Well
=ROUNDUP(16.621,2)
is much clearer than
=CEILING(16.621,0.01)
IMO.
--
** John C **

"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"Rebecca_SUNY" wrote in message
...
Could someone explain the difference between ROUNDUP and CEILING?