Better Sheets

How to Use NPER() in Google Sheets

Description

Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

How To Actually Use NPER() in Sheets

NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])

Try NPER yourself

In cells A1 to A3, enter the interest rate, the payment amount, and the present value of an investment. Use the NPER formula in cell A5 to calculate the number of periods needed to pay off the investment.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for NPER(). Click through to watch.

Browse more tutorials

Add NPS to Your Google Site

Create buttons on your Google Site to get an NPS, or Net Promoter Score ...

Intermediate

AVERAGE()

Unlock these tutorials

Learn more about the NPER() formula:

Generate a NPER() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses NPER(). 2 free AI generations, no signup. Members get unlimited use.

Generate a NPER() formula

How to Use NPER() in Google Sheets

Try NPER yourself

More related tutorials

Add NPS to Your Google Site