My question is linked to this one: Excel Question
I would like to subtract a fixed amount to a total on the 1st of each months.
See an example of what I would like please (no interests calculation needed):
Let's say the first cell is A1 then A2, A3, A4.
The first 2 cells should have no formula whatsoever, these are fixed amounts.
total amount left to repay | Amount paid every month | balance (A1-A2 calculated automatically every 1st of each month) | Number of months left until balance (A3) is 0
Is this possible please?
thanks so much