Need a formula to calculate the number of months to pay off a loan

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

Guest

I need a formula to calculate the number of months it will take to pay off a
loan, given interest rate, balance and the amount of payments.
 
Look in HELP for the NPER() function

Make sure you use monthly rate if you require number of months

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top