| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change mixed case to upper case in Excel for all cells | Excel Discussion (Misc queries) | |||
| Rounding up results to meet minimum order quantities. | Excel Worksheet Functions | |||
| Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
| How do I change a column in Excel from upper case to lower case? | Excel Worksheet Functions | |||
| How to use formula auditing to change upper case to Title Case. | Excel Worksheet Functions | |||
Hybrid Mode
