Rounding to case quantities

C

Carelle

I'm working with an order form and need a formula that converts an "each"
qty. to a case qty. For example - I need 55 each of an item but can only
order in cases of 24 each.

D21=24 (case qty.)
F21=55 (qty needed)
G21= formula = total each to order based on case qty. (should be 72 each in
this example)

Hope this is clear.
 
S

Stephen

Carelle said:
I'm working with an order form and need a formula that converts an "each"
qty. to a case qty. For example - I need 55 each of an item but can only
order in cases of 24 each.

D21=24 (case qty.)
F21=55 (qty needed)
G21= formula = total each to order based on case qty. (should be 72 each
in
this example)

Hope this is clear.
Click to expand...

=ROUNDUP(F21/D21,0)*D21
 
Top