I need to round up to the nearest 50.

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

[Bob Phillips]

=ROUNDUP(A21/50,0)*50

or

=CEILING(A21,50)

--
HTH

Bob Phillips

"karenm" <karenm@discussions.microsoft.com> wrote in message
news:DBE54F5E-0524-4DFF-BC52-D966BBEE26E9@microsoft.com...
> 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?
>

[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



"karenm" <karenm@discussions.microsoft.com> wrote in message
news:DBE54F5E-0524-4DFF-BC52-D966BBEE26E9@microsoft.com...
>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?
>

[KL]

Opps!

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

KL


"KL" <NOSPAMlapink2000@PLEASEhotmail.com> wrote in message
news:Op6jH%23GuFHA.2592@TK2MSFTNGP09.phx.gbl...
> 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" <karenm@discussions.microsoft.com> wrote in message
> news:DBE54F5E-0524-4DFF-BC52-D966BBEE26E9@microsoft.com...
>>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?
>>
>
>