How to use the MIRR function in Excel office 365? ~ {Quick Steps}
Tags: tousethemirrfunction, excel, excelfunctions
Published: 2021-09-02 02:11:55

---
title: How to use the MIRR function in Excel office 365? ~ {Quick Steps}
published: true
date: 2021-09-01 10:33:46 UTC
tags: ToUseTheMIRRFunction,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-mirr-function-in-excel-office-365-quick-steps/
---

In this article, we are going to see how to  **use the MIRR**  **Function In Excel Office 365.**  Let’s get into this article!! Get an 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)**

## MIRR Function

This function returns the **Modified interest rate of return for the financial data** having **Investment, finance rate & reinvestment\_rate** , and it returns modified **interest rate of return in percentage**.

## MIRR Function Syntax

```
=MIRR (values, finance_rate, reinvest_rate)
```

**Syntax Explanation:**

- **Values:** Investment amount (both positive & negative amount) or cash flows in array.
- **Finance\_rate:** Required rate of return (discount rate) as a percentage.
- **Reinvest\_rate:** Interest rate received on cash flows reinvested as percentage.

## Example1

- Firstly, you have to **create a sample data** with **Investment, Finance\_rate & reinvestment\_rate**.

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

- Then, you need to calculate the **MIRR Function value**.
- Now, you have to use the following **formula** given below.

```
=MIRR(A2:A6, B2, C2)
```

**A2:A6:** investment amount or cash flow.  
**B2:** finance\_rate.  
**C2:** Reinvest\_rate.

![](https://geekexcel.com/wp-content/uploads/2021/09/MIRR-Function-1024x353.png)<figcaption>MIRR Function</figcaption>

- Finally, the **MIRR function** returns the modified **interest rate** of return is **8.1%**.

## Example2

- Firstly, you have to **create a sample data** with **Investment, Finance\_rate & reinvestment\_rate**.

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

- Then, you need to calculate the **MIRR Function value**.
- Now, you have to use the following **formula** given below.

```
=MIRR(A2:A6, B2, C2)
```

**A2:A6:** investment amount or cash flow.  
**B2:** finance\_rate.  
**C2:** Reinvest\_rate.

![](https://geekexcel.com/wp-content/uploads/2021/09/Ex-2-MIRR-Function-1024x341.png)<figcaption>MIRR Function</figcaption>

- Finally, the **MIRR function** returns the modified **interest rate** of return is **12.5%**.

**Check this too:**

- [PPMT function](https://geekexcel.com/how-to-use-the-ppmt-function-in-excel-office-365/)
- [R-Squared(RSQ) Function](https://geekexcel.com/how-to-find-r-squaredrsq-function-in-excel-office-365/)
- [NPER Function](https://geekexcel.com/how-to-use-the-nper-function-in-excel-office-365/)

## Wind-Up

We hope that this short tutorial gives you guidelines to **use the MIRR**  **Function In Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Next:**

- **[How to use the IMSQRT Function in Excel Office 365?](https://geekexcel.com/how-to-use-the-imsqrt-function-in-excel-office-365/)**
- **[How to Use IMSUB Function in MS Excel 365? – { With Examples }](https://geekexcel.com/how-to-use-imsub-function-in-ms-excel-365-with-examples/)**
- **[Use IMSUM Function in MS Excel 365? – (With Examples)](https://geekexcel.com/how-to-use-imsum-function-in-ms-excel-365-with-examples/)**
- **[How to Use IMPRODUCT Function in Excel 365? – [with Examples]](https://geekexcel.com/how-to-use-improduct-function-in-excel-365-with-examples/)**
- **[How to use the IMTAN Function in Excel office 365?](https://geekexcel.com/how-to-use-the-imtan-function-in-excel-office-365/)**