Rounding to case quantities

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a formula to sum quantities by part number? 3
Formula to auto-assign number 4
Formula to auto-assign number 2
sumproduct??? 2
Running total on a report 2
Summing quantities based on like criteria? 5
In anguish -- need Lookup help 1
Desperately Need Help. Technic To Return Date 2

Top