HELP with an unorthadox AM schedule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi and thank you all!

I have an AM table (and I have done many), but I need a command to:

1) When the End of Balance = 0, then
2) Sum all PMTs BEFORE the End of Balance = 0

I am very appreciative and would be happy to compensate any who can help.
Please see attached spreadsheet.
 
I'm sure the gurus here will come up with a better solution, but my advice would
be to modify the payment column, to something like:

=if(balance<=$payment,balance,$payment)

This also handles a non-standard final payment.

Now when you sum the column, all payments after the balance is paid off are
zero, and have no effect on the sum.
 
Back
Top