Create a function

[slava]

Please help create a function that will create additional column "remainder". This solution should calculate the remainder according to the logic illustrated in our provided screenshot, where each successive row reduces the quantity accordingly. I would be very grateful for your help (ChatGPT and Copilot can't help). Thanks

 

[AliGW]

Please attach a sample Excel workbook with yoyur requirements mocked up.

 

[slava]

Hi, enclosed
Thanks

 

[AliGW]

Pleae explain the logic of your expected results - I don't get it.

 

[slava]

Hi
The Table2 is a warehouse
The Table1 is a production
I need to get the remainder after each production iteration
1 iteration of prouction requires 14 qty of "B8-510-1050"
But this product is not avilable in warehaus then 0-14=-14
2 iteration of prouction requires 42 qty of "B8-510-1050"
But this product is not avilable in warehaus then 0-42=-42
3 iteration of prouction requires 25 qty of "B8-614-0500"
then 93("B8-614-0500"Table2) - 25("B8-614-0500"Table1)=68
4 iteration of prouction requires 25 qty of "B8-614-0500"
the remainder of "B8-614-0500" in the warehouse is 68 after 3 iteration
then 68("B8-614-0500"Table2) - 25("B8-614-0500"Table1)=43
etc.
Thanks