excell

  • Thread starter Thread starter scott haupt
  • Start date Start date
S

scott haupt

i am trying to have a formula calclate a next days shippig qty
based on same day forecast to end up with a next days on hand with a minimum
inventory rounded up by multipls of 8 pcs
 
i am trying to have a formula calclate a next days shippig qty
based on same day forecast to end up with a next days on hand with a minimum
inventory rounded up by multipls of 8 pcs
Click to expand...

Try something like this to round up to the nearest multiple of 8:
=CEILING(F4+.1,8)

The "+.1" is to make sure it rounds up if F4 is already a multiple of
8, otherwise it wouldn't increase the number.
 
Back
Top