I have am quite new to this so please bear with me!
I have been racking my brain but i cant figure this out!
I have 5 fields: MoneyIn, Debt, TechLoan, OutstandingDebt, OutstandingTech.
Debt and Techloan do not change from their original value.
So for example the debt = 5000, techloan = 5000 and money in = 8000 (which I input). I want to subtract the debt from the money in and then populate Outstanding debt with 0 then carry over the remaining debt to subtract from Techloan and populate OutstandingTech with 3000.
So what i am trying to do is if the money in clears debt 1 carry over to debt 2 and clear as much of that as possible.
I have been attempting this for days now and i am not getting anywhere. Could some suggest a way i could do this? Or some guidence where to start!
Any help will be fantastic!