I am trying to subtract number from one column until zero then subtract remaining balance from the next column.
Example
Excel.png
If i put a number in j7 i would like it to subtract it from c7 and give a balance in m7. Then if i put a number in k7 it will update m7 and so on until m7 is zero. Then I would like it to subtract it from d7 and update the balance in r7. Finally if i put a number in o7 it will update r7 accordingly.
Bookmarks