HelpExcelHelpers
New Member
- Joined
- May 5, 2018
- Messages
- 15
I | J | K | L | M | |
1 | 100 | 200 | 0 | 175 | 125 |
2 | 0 | 125 | 0 | 175 | 125 |
<tbody>
</tbody>
ROW ONE: When entering a value in L1, I would like the amount to deduct from I1 until it reaches zero before deducting from J1. M1 is the balance for the row
ROW TWO: Is how it should look if the formula is correct.