Disclaimer: I admit this is cross-posting, as I had first posted this on Excelforms and I did not get the solution that I am looking for.
Please refer to the below snapshot. I want your help to be able to allocate available stock as shippable and alongside it running Stock leftover until it gets exhausted.
So in here I have some dummy order numbers and 3 material in stock and based on the ordered quantity I want to allocate available stock until it becomes zero.
I tried using nested-if, but since my actual data is too big and some of the cases where for some of the materials the rows are more than 30, I found it difficult to arrive at a formula that suffices my above requirement of allocating shippable and showing stock leftover, if any.
Thanks for your help in advance.