Functions
NPER
Number of payment periods
Try it
When to use it
When should I use NPER instead of RATE?
Use NPER to solve for the number of payment periods; use RATE to solve for the interest rate per period.
Use cases
Periods needed to reach a savings goal
Years to grow a lump sum to a target
Used in
finance · lending · personal-finance
Syntax
NPER(rate, pmt, pv)Examples
=NPER(2,500,40000) // => -4.625293579361693
=NPER(0.12/12,-100,-1000,10000,1) // => 59.67386567429457