I need to round up to the nearest 50.

K

karenm

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?
 
K

KL

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
 
Top