Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.
81% OFF online library of tutorials for mastering Google Sheets
81% OFF online library of tutorials for mastering Google Sheets
One time purchase $199
Description
How To Use in Sheets
NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])
External Links
I demonstrate how to use the Number of Periods (NPER) function in Google Sheets. NPER is used to determine how long it will take an investment to reach its goal.
0Better Sheets Tutorials
No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.