Forum Discussion
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 ...
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.