Forum Discussion
Terminator
Oct 20, 2024Copper Contributor
Stock Allocation Against Available stock & Credit Limit
Hi, Pls go thru my file, with reference to other post (https://techcommunity.microsoft.com/t5/excel/to-allocate-stock-from-closing-stock-by-formula/m-p/510624) I made my sheet but I need to add few ...
FinchleyKnight
Mar 18, 2025Iron Contributor
It allocates the minimum of the Required Quantity, Available Quantity, or the maximum quantity that can be covered under the Credit Limit (calculated as H2/G2, where G2 is the price). Adjust the ranges (E2, F2, H2, G2) based on your actual row references.