The IRR function in Excel calculates the Internal Rate of Return for a series of cash flows (payments and income).It is used heavily in finance and investment analysis to measure and compare the profitability of different projects or investments. In simple words:IRR tells you how profitable your investment is, shown as a percentage