How to use the NPER Function in Excel office 365?
Tags: tousethenperfunction, excel, excelfunctions
Published: 2021-08-30 07:21:57

---
title: How to use the NPER Function in Excel office 365?
published: true
date: 2021-08-27 17:38:40 UTC
tags: ToUseTheNPERFunction,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-nper-function-in-excel-office-365/
---

In this article, you will learn how to use the **NPER Function In Excel Office 365** using its basic syntax, explanation, and examples. Let’s see them below!! Get the official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## NPER Function

- It is used to find **total monthly installment periods** on a **loan amount** using the function having **principal amount or loan amount** , **interest rate per period** , **installment amount & number of periods in a year**.
- The function calculates the **payment periods for a loan** based on **constant payments** and a **constant interest rate**.

## NPER Function Syntax

```
=NPER (rate, pmt, pv, [fv], [type])
```

**Syntax Explanation:**

- **rate** – The interest rate per period.
- **pmt** – installment, amount paid on each period.
- **pv** – The present value, the total amount that a series of future payments is worth now.
- **[fv]** – [optional] pending amount after the loan. If omitted, default is zero.
- **[type]** – [optional] The timing of the payment, either at the beginning or end of the period. Numbers 0 or 1 represent the payment date. The number 0 represents payment at the end of the period, and the number 1 represents payment at the beginning of the period. The default (empty argument) is 0. The calculation considers payment is at the end of the period.

## Example1

- Firstly, you have to **create a sample data** with **inputs**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-41.png)<figcaption>Sample data</figcaption>

- Then, you need to find out the **total number of payments** on the loan.
- Now, you have to use the following **NPER Function formula** given below.

```
=NPER(B2/12,C2,A2)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/NPER-formula.png)<figcaption>NPER Function</figcaption>

- After that, all the **arguments** to the function is given as **cell reference**.
- Finally, you will get the **total number of payments as 60**.

## Example2

- Firstly, you have to **create a sample data** with **inputs**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Ex-2-Sample-data-4.png)<figcaption>Sample data</figcaption>

- Then, you need to find out the **total number of payments** on the loan.
- Now, you have to use the following **NPER Function formula** given below.

```
=NPER(B2/12,C2,A2)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/Ex-2-NPER-function.png)<figcaption>NPER Function Formula</figcaption>

- After that, all the **arguments** to the function is given as **cell reference**.
- Finally, you will get the **total number of payments as 60**.

**Check this too:** [How to Find R-Squared(RSQ) Function in Excel office 365?](https://geekexcel.com/how-to-find-r-squaredrsq-function-in-excel-office-365/)

## Verdict

From this chapter, you can get some clarification about **how to use the NPER**  **Function In Excel Office 365**. Let me know if you have any **doubts** regarding this article or any other Excel/VBA topic.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Related Articles:**

- **[Excel Formulas to Calculate the Cumulative Loan Principal Payments!!](https://geekexcel.com/excel-formulas-to-calculate-the-cumulative-loan-principal-payments/)**
- **[Formulas to Calculate the Interest for Given Period ~ Quickly!!](https://geekexcel.com/excel-formulas-to-calculate-the-interest-for-given-period/)**
- **[Excel Formulas to Calculate the Payment for a Loan ~ Useful Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-the-payment-for-a-loan/)**
- **[Excel Formulas to Calculate Loan Interest in Given Year ~ Simple Tips!!](https://geekexcel.com/excel-formulas-to-calculate-loan-interest-in-given-year/)**
- **[How to use the CUMPRINC function in Excel Spreadsheet?](https://geekexcel.com/how-to-use-the-cumprinc-function-in-excel-spreadsheet/)**