| 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 |
| 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 | |||
Threaded Mode
