On Google sheets (which is the same as excel so I’m told).

I’ve figure out the “=pmt” part, but how do I get it to display the new balance each time a payment is made?

So the loan is 10,000.00.

Payment is 110 biweekly.

I’ve tried programming the balance cell as follows: “=10,000.00-110”* or more precisely: “cell the loan amount is in-cell the payment amount is in”.

But that’s not working.

ETA: Loan is interest free.

Thanks