Remove #NUM errors this way! ... such as IRR or RATE, ... the more accurate the result, and the more time Excel needs to calculate a worksheet. Then click OK. Read: How to add, ...

Learn how to calculate the internal rate of return (IRR) in Excel and how it’s used to determine whether a capital investment can be profitable.

Excel and Google Sheets have three functions to calculate the internal rate of return: IRR, XIRR, and MIRR. Learn how these functions can calculate investment returns.

1. Excel’s IRR function. Excel’s IRR function calculates the internal rate of return for a series of cash flows, assuming equal-size payment periods. Using the example data shown above, the IRR ...