Hi everyone,

If A1 is my amount outstanding(eg. 1000) and B1 is what I pay monthly(eg.100) How do I make C1 show the running total as it ticks down automatically month by month.
Also, how do I make D1 show how many payments are left?
There is no interest rate.

Many thanks.