How to Use Excel IRR Function in Office 365? – {with Examples}
Tags: excelfunctions, excelirrfunctioninof
Published: 2020-09-28 07:59:46

---
title: How to Use Excel IRR Function in Office 365? – {with Examples}
published: true
date: 2020-09-28 07:02:43 UTC
tags: ExcelFunctions,ExcelIRRFunctioninOf
canonical_url: https://geekexcel.com/how-to-use-excel-irr-function-in-office-365-with-examples/
---

## Excel IRR Function:

![IRR Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/IRR-Function.png)<figcaption id="caption-attachment-14660">IRR Function</figcaption>

In this article, you will understand how to use the **Excel IRR Function in Office 365** with its syntax, explanation, and example. Let’s get started!! 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)
## **IRR Function – Description:**

- This function **returns the internal rate of return for a series of cash flows that occur at regular intervals such as monthly or annually.**

## **Syntax:**

**=IRR(values, [guess])**

### Arguments Description:

**Values – ** It is the array or reference to cells that contain numbers for which you want to calculate the internal rate of return.

**Guess – ** It is an optional one. It is an estimate for the expected IRR. By default, this is assigned as **.1 (10%)**

### Note:

- If guess is any non-numerical value such as letters and then it returns [**#NAME? Error**](https://geekexcel.com/how-to-fix-name-error-in-excel-office-365-with-example/).
- If the argument guess is a negative number, then it returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).
- The array values should contain at least one positive value and one negative value.

## **Examples:**

Let’s see some examples to make you understand this function easily.

### Example 1:

- In the below screenshot, you can see the **input values** in **Column**  **B ** and the output value is displayed in **Cell D4.**

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

### Example 2:

- If the guess is any non-numerical value such as letters and then it returns [**#NAME? Error**](https://geekexcel.com/how-to-fix-name-error-in-excel-office-365-with-example/).

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

### Example 3:

- If the argument guess is a negative number, then it returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

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

From the above examples, you can learn how to use **IRR** Function.

## **Closure:**

In this article, you can learn the usage of **Excel IRR Function in Office 365** with its syntax, explanation, and examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Use Excel DPRODUCT Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-dproduct-function-in-office-365-with-examples/)
- [How to Use Excel MROUND Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-mround-function-in-office-365-with-examples/)