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


--
Thanks,
Carelle

=ROUNDUP(F21/D21,0)*D21