IRR Function in Excel: Syntax, Examples and Free Practice
IRR is an Excel Financial function. Estimates the internal rate of return for a series of cash flows.
IRR syntax
Arguments
values: The series of cash flow valuesguess: A starting estimate for the calculation (optional)
When to use IRR
IRR is used in loan, investment, or valuation models where precise financial math is required.
Practice IRR online, free
Open the live Excel-style spreadsheet and try IRR yourself. No Excel install or sign-up needed to start.
Practice IRR now →More Financial functions
Frequently asked questions
What does the IRR function do in Excel?
Estimates the internal rate of return for a series of cash flows.
What is the syntax of IRR in Excel?
The syntax is =IRR(values, [guess]). values: The series of cash flow values; guess: A starting estimate for the calculation (optional).
Where can I practice IRR online for free?
Open the free live spreadsheet on Cellgrids and try IRR yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Financial functions · Excel case studies · Excel tutorials · Excel shortcuts