Rounding to case quantities
 

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

Rounding to case quantities
 

=ROUNDUP(F21/D21,0)*D21
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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

Rounding to case quantities
 

"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

Rounding to case quantities
 

You just saved me hundreds of hours - thank you so much!
--
Thanks,
Carelle


"Bernard Liengme" wrote:

=ROUNDUP(F21/D21,0)*D21
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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