RRI function

RRI returns the annual compound growth rate required to grow an investment from its present value to a future value over a specified number of periods.

=RRI(nper, pv, fv)

Generate a RRI formula

Describe what you need. The generator will reach for RRI where RRI is the right tool, and tell you when it is not.

How to get a better answer
  • Name your columns by letter and by header: "column F (Net Value)" beats "the amount column".
  • State every condition, including the negatives — "not cancelled" changes the formula's shape.
  • Say where the data starts if it is not row 1, and whether it will grow.
  • Check the settings above match your spreadsheet: the wrong argument separator is a syntax error on your machine.

Arguments

How RRI reads its arguments
nperrequiredpvrequiredfvrequiredRRI →
ArgumentRequiredDescription
nperRequiredNumber of periods; must be positive. Typically represents years, but can be months or quarters if your data frequency matches. Zero or negative values return #NUM! error.
pvRequiredPresent value (starting amount), entered as a positive number. If zero, returns #VALUE! error since a growth rate cannot be calculated from a zero base.
fvRequiredFuture value (ending amount). Can be any real number; if less than pv, RRI returns a negative rate (representing loss or depreciation).

Returns

A decimal representing the rate of return per period (e.g., 0.15 means 15%).

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Calculate annual maintenance cost growth for a single vehicle

YearTruck A Cost
2021850
20252100
=RRI(4, 850, 2100)

Result: 0.2497

Truck A's maintenance costs grew from $850 in 2021 to $2,100 in 2025 over 4 years. RRI calculates that a 24.97% annual compound growth rate explains this change, indicating maintenance expenses escalated at roughly 25% per year.

2. Track total fleet maintenance budget expansion over time

YearFleet Total
20211620
20254880
=RRI(4, 1620, 4880)

Result: 0.3212

Total fleet maintenance across three vehicles (Truck A, Van B, Car C) grew from $1,620 in 2021 to $4,880 in 2025. The 32.12% annual compound growth rate reflects rapidly increasing service costs across the entire fleet.

3. Measure maintenance cost escalation for a specific vehicle over 3 years

YearVan B Cost
2021420
20241800
=RRI(3, 420, 1800)

Result: 0.6247

Van B's maintenance costs jumped from $420 in 2021 to $1,800 in 2024 across 3 years. The 62.47% annual rate reveals severe mechanical deterioration requiring expensive repairs or transition to higher-tier service packages.

Common errors

Which RRI error are you seeing?
RRI returned an error#NUM!
Verify your period calculation. If comparing 2021 to 2025, use nper=4 (not 0 or -1). Ensure dates were subtracted correctly before entering into RRI.
#VALUE!
Ensure pv is a positive number representing your opening balance. Check that cells reference numbers, not text like '850' with quotes. Use VALUE() to convert text strings if needed.
#VALUE!
Verify all three arguments are numeric values. Convert text dates to actual date serials. Use ISNUMBER() to debug; ensure your Cost column contains numbers, not text.
ErrorWhy it happensHow to fix it
#NUM!nper is zero or negative. RRI cannot calculate a growth rate without a valid time period.Verify your period calculation. If comparing 2021 to 2025, use nper=4 (not 0 or -1). Ensure dates were subtracted correctly before entering into RRI.
#VALUE!pv (present value) is zero or negative, or arguments contain text. RRI cannot compute a rate when starting from zero or invalid input types.Ensure pv is a positive number representing your opening balance. Check that cells reference numbers, not text like '850' with quotes. Use VALUE() to convert text strings if needed.
#VALUE!Arguments are not numeric—for example, referencing a text-formatted cell, a date stored as text, or a cell containing a formula error.Verify all three arguments are numeric values. Convert text dates to actual date serials. Use ISNUMBER() to debug; ensure your Cost column contains numbers, not text.

Tips and when to use something else

  • RRI returns a decimal; multiply by 100 or format the cell as Percentage to display as text (e.g., 0.2497 displays as 24.97%).
  • Use RATE() instead if you have periodic payments (e.g., monthly contributions). RRI is for lump-sum investments only.
  • For irregular cash flows across multiple years, use IRR or XIRR; RRI handles only two values (start and end).
  • Ensure nper units match your data frequency: use years if comparing annual totals, quarters if comparing quarterly snapshots, otherwise your rate will be misaligned with reality.

Related functions

RATERATE calculates the interest rate per period for an investment or loan given regular periodic payments and present/future values.IRRReturns the internal rate of return for a series of regular periodic cash flows, measuring annualized investment profitability.XIRRXIRR returns the annualized internal rate of return for cash flows at irregular date intervals, letting you evaluate project or investment profitability over time.FVFV returns the future value of a series of regular cash flows at a constant interest rate, modeling compound growth over time.PVReturns the present value of an investment based on a series of regular payments and a constant interest rate.

Frequently asked questions

What's the difference between RRI and RATE?
RRI calculates the rate for a lump-sum investment growing from one value to another over a given period. RATE is designed for periodic payments (loans or annuities). If your maintenance budget has regular contributions or withdrawals throughout the years, use RATE or IRR instead.
How do I apply RRI to monthly or quarterly data instead of annual?
Set nper to the number of months (or quarters) between your start and end dates, and the result will be the monthly (or quarterly) rate. To convert to an annual rate, raise the monthly rate to the 12th power and subtract 1, or divide by 12 as an approximation.
Can RRI return a negative result?
Yes. If fv is less than pv, RRI returns a negative rate, indicating depreciation or loss. For example, if a vehicle worth $15,000 depreciates to $9,500 over 4 years, =RRI(4, 15000, 9500) returns approximately -0.1183, showing an 11.83% annual decline.
Why does my RRI formula show #VALUE! when my numbers look correct?
Often the cells contain text that looks like numbers (e.g., '850' stored as text rather than 850 as a number). Check that your Cost column is formatted as Number, not Text. Use =ISNUMBER() to verify; if it returns FALSE, convert with =VALUE() or re-enter as a true number.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17