Forum Discussion
If loan is X, and rate is Y, and I pay Z each payment, how many payments until pd in full?
I have an amortizing loan formula solving the problem, "If my loan amount is X, and my interest rate is Y, and I pay Z each payment, how many payments will I make to pay off the loan? I solved it by...
IF I understood you correctly--and it's entirely possible that I didn't--then this formula does what you want.
=INDEX(U26:U386,MATCH(0,V26:V386,-1))
This retrieves the number 244, and I think that's what you wanted the formula to return. It does it by first finding the spot in the balance column where the numbers is just about to turn negative, and then gives that "index" to Excel to find the corresponding payment number in column "U"
If I that's NOT what you were looking for, come back and try to describe it a bit more carefully.
