How to Use Excel RRI Function in Office 365? [With Examples]
Tags: excelfunctions, excelrrifunctioninof, rrifunctioninoffice3
Published: 2020-10-02 07:58:40

---
title: How to Use Excel RRI Function in Office 365? [With Examples]
published: true
date: 2020-10-02 04:23:33 UTC
tags: ExcelFunctions,ExcelRRIfunctioninOf,RRIfunctioninOffice3
canonical_url: https://geekexcel.com/how-to-use-excel-rri-function-in-office-365-with-examples/
---

## Excel RRI Function:

![RRI function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/RRI-function.png)<figcaption id="caption-attachment-14954">RRI function</figcaption>

This article describes the description, basic syntax, and usage of the **Excel RRI function** in **Office 365**. Get an official version of **Microsoft Excel** from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel).**
## RRI Function – Description:

- The Excel RRI function **calculates the equivalent interest rate for the growth of an investment**.
- RRI calculates the interest rate using the below equation.

[![RRI Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/RRI-Formula.png)](https://geekexcel.com/?attachment_id=14953#main)<figcaption id="caption-attachment-14953">RRI Formula</figcaption>

## Syntax of RRI Function:

```
=RRI(nper, pv, fv)
```

### **Argument Description:**

- **Nper (Required)** – It is the number of periods for the investment.
- **Pv (Required)** – It is the present value of the investment.
- **Fv (Required)** – It is the future value of the investment.

### Important Note:

- [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/) – The function returns the #VALUE! Error if any one of the input arguments contains a non-numeric character.
- [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/) – This error occurs if either nper or pv argument is zero or any one of the supplied arguments is negative.

## Practical Examples:

Let’s look at some examples of this **RRI function** and explore how it works in Microsoft Excel.

### **Example 1:**

- First, we need to enter the input values of the year, present value, and future value.
- Here, we have entered into the cell range C5: E7.
- In this example, we have selected the input cells C5, D5, E5 to calculate the interest rate.
- Refer to the below syntax of the  **RRI function**  to return the output.

```
=RRI(C5, D5, E5)
```

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-1.png)<figcaption id="caption-attachment-14950">Example 1</figcaption>

- In order to execute the formula, you need to press the **Enter** key.

![Example 1 - Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-1-Output.png)<figcaption id="caption-attachment-14949">Example 1 – Output</figcaption>

- Now, you can see the result in the G5 cell.
- For other input values, you just repeat the same procedure. In another way, you can just drag the cell G5 to G7 in order to return the respective output automatically.

### **Example 2:**

- The **#VALUE! error** will be returned if **any one of the input arguments contains a non-numeric character**.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-2.png)<figcaption id="caption-attachment-14951">Example 2</figcaption>

### **Example 3:**

- If either **Nper or Pv value is 0 (zero)** or **any one of the arguments is negative** , then the function returns the **#NUM! error**.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-3.png)<figcaption id="caption-attachment-14952">Example 3</figcaption>

## Verdict:

In the above short article, we have described the explanation, basic syntax, and usage of the **Excel RRI function** in **Office 365** with the examples. Drop your valuable **queries/feedback** in the below comment section. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning with us!!

## Related Articles:

- **[How to Use Excel SLN Function in Office 365? (\*With Examples\*)](https://geekexcel.com/how-to-use-excel-sln-function-in-office-365-with-examples/)**
- **[How to Use Excel ISNA Function in Office 365?](https://geekexcel.com/how-to-use-isna-function-in-microsoft-excel-365/)**
- **[Excel DBCS Function in Office 365 – Definition with Practical Examples!!](https://geekexcel.com/excel-dbcs-function-definition-with-practical-examples/)**
- **[Use Excel N Function in Office 365 -Simple methods!!](https://geekexcel.com/use-n-function-in-microsoft-excel-365-simple-methods/)**