Hello, what I would need is a formula that can calculate the following: in the amount column is the amount we deposit to employee`s account, in the advance column is if we give them some money before the actual payday, so the outstanding balance should be the amount they ``owe`` us and in the next row , once we deposit them money again it negative balance should be cleared and the remaining balance should be calculated, for example if they owe us 200, and their salary is 500, what they get is 300, also, if they didn't get any advance, $500 is deposited in the balance should be 0.

dsds.png