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

On May 15, 9:48 pm, scott haupt <scott
wrote:
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

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.