81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Calculates the internal rate of return on an investment based on a series of periodic cash flows.

How To Use in Sheets

IRR(cashflow_amounts, [rate_guess])

External Links

Google Sheets IRR Function | Calculate Internal Rate of Return | Google Sheets Functions

Google Sheets IRR function returns the interest rate by which an investment would grow based on the investment, any other cash outflows, and the cash inflows at regular periods. The IRR function helps to find the investment option, from two or more investment choices, with a better profitability.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.