FinancialLevel: ExpertAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Common errors and fixes
- Related functions
IRR returns the rate at which the NPV of regular, equally spaced cash flows is zero. For irregular dates use XIRR.
Syntax
=IRR(values, [guess])
| Argument |
What it means |
values |
Cash flows; first is usually the negative investment. |
Examples
Example 1
=IRR(B2:B7)
Project return from yearly cash flows −10L, 2L, 3L, 3.5L, 3L, 2L.
Common errors and fixes
| You see |
Why, and the fix |
#NUM! |
No sign change in the cash flows, or it can’t converge — give a guess like 10%. |
XIRR · NPV · MIRR
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong