Forum Discussion
Formula or Macro
What is the Formula for the following:. Column E is the monthly payment due of $277.05 and column K is the amount actually paid each month, Column L is the next payment due? If column K is $300.00 ...
I have a feeling there is more to it than you describe, but with what you give us, in L2:
=MAX(2*E2-K2, 0)
I have a loan calculation spreadsheet. The monthly payment is 277.05. If I pay more in one month how much does it lower the next month payment to?