FinancialLevel: IntermediateAvailable in: Excel 2013+
In this article
- Syntax
- Examples
- Example 1
- Related functions
RRI returns the constant growth rate needed to go from a start value to an end value — i.e. CAGR in one function.
Syntax
=RRI(nper, pv, fv)
| Argument |
What it means |
nper |
Number of periods (years). |
Examples
Example 1
=RRI(5, 1000000, 1800000)
Revenue from ₹10L to ₹18L in 5 years: about 12.5% CAGR.
POWER · RATE · XIRR
📚 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