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 ...
Your formula will first need to check if the customer has an available credit limit. If the credit limit is zero or negative, you would allocate a quantity of zero.