Rounding up results to meet minimum order quantities.

There was a formula I used in the past that would bump up the results in a
cell to the next highest group of ten. For example, if the results were "16"
the formula would return "20". If the results were "32" the formula returns
"40" and so on. I would like to use this function again but can't remember
the formula. Any assistance will be appreciated. Thanks! Vince

=CEILING(A1,10)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Vin C." <Vin [email protected]> wrote in message
news:[email protected]...
> There was a formula I used in the past that would bump up the results in a
> cell to the next highest group of ten. For example, if the results were
"16"
> the formula would return "20". If the results were "32" the formula
returns
> "40" and so on. I would like to use this function again but can't
remember
> the formula. Any assistance will be appreciated. Thanks! Vince

How about =ROUNDUP(A1,-1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Vin C." <Vin [email protected]> wrote in message
news:[email protected]...
> There was a formula I used in the past that would bump up the results in a
> cell to the next highest group of ten. For example, if the results were
> "16"
> the formula would return "20". If the results were "32" the formula
> returns
> "40" and so on. I would like to use this function again but can't
> remember
> the formula. Any assistance will be appreciated. Thanks! Vince