I need to round up to the nearest 50.
 

I am trying to calculate the number of raw material bags I need in a batch.
If I use the mround function is will round down. Is there a way to only
round up?

=ROUNDUP(A21/50,0)*50

or

=CEILING(A21,50)

--
HTH

Bob Phillips

"karenm" wrote in message
...
I am trying to calculate the number of raw material bags I need in a
batch.
If I use the mround function is will round down. Is there a way to only
round up?

Hi karenm,

First of all, I believe MROUND rounds number according to the mathematical
rules, not just DOWN or UP.

You can use the following formulae for your case:

=ROUNDUP(A1/50,0)*50
=CEILING(A1/50,1)*50

Regards,
KL



"karenm" wrote in message
...
I am trying to calculate the number of raw material bags I need in a batch.
If I use the mround function is will round down. Is there a way to only
round up?

Opps!

The second formula should actually read:
=CEILING(A1,50)

KL


"KL" wrote in message
...
Hi karenm,

First of all, I believe MROUND rounds number according to the mathematical
rules, not just DOWN or UP.

You can use the following formulae for your case:

=ROUNDUP(A1/50,0)*50
=CEILING(A1/50,1)*50

Regards,
KL



"karenm" wrote in message
...
I am trying to calculate the number of raw material bags I need in a
batch.
If I use the mround function is will round down. Is there a way to only
round up?