Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have excel spreadsheet that shows how much inventory I have on hand in
weeks, how much minimum inventory to keep and the max inventory to have I need to know if there is a formula that can tell me exactly what to order for the future? Listed below is what I have so far: Max Inv. # of Weeks in Inventory Order Amount Minimum Inv. 15300 2.06 ? 3400 If the inventory falls below 1.75 weeks I need a formula to show how much to order according to min and max quantity. Thank you, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Can I add a quantity to every cell in a column using a formula? | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |