View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default Rounding up results to meet minimum order quantities.

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

"Vin C." <Vin wrote in message
...
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