Round up to the nearest divisible quantity

  • Thread starter Thread starter bjl
  • Start date Start date
B

bjl

Is there a formula or statement that will check to see if a quantity i
evenly divisible by a certain # and if not the result would be rounde
up to the next increment.

Example: I need to buy 75 items but they need to be purchased i
quantities of 8.

The result of the formula should be 80.

Thanks for the help.
Barbar
 
My bad...........Frank and JE were correct of course..........

should be =CEILING(F1,8)

sorry
Vaya con Dios,
Chuck, CABGx3


CLR said:
=CEILING(F1,10)

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Back
Top