Calculates the internal rate of return for an investment where the payments occur at regular intervals, such as monthly or annually.

**Sample Usage**

IRR(A3:A7)

**Syntax**

IRR(values, [guess])

- values - The series of payments entered as a cell reference.
- guess - [OPTIONAL] Estimated internal rate of return value. The default is 10%.

**Examples**

IRR(A3:A7) calculates the internal rate of return for payments A3:A7, with an internal rate of return value of 10%.

**Notes**

- If the days specified in dates are at an irregular interval, use XIRR instead.
- Each cell in values should be positive if it represents income from the perspective of the owner of the investment or negative if it represents payments.
- values must contain at least one negative and one positive cash flow to calculate rate of return.