81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows.

How To Use in Sheets

XIRR(cashflow_amounts, cashflow_dates, [rate_guess])

External Links

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.