RRI Function in ONLYOFFICE Spreadsheet Editor: Syntax, Examples and Troubleshooting

• Introduced: The original introduction version and date are not established by the official sources checked.
• Availability: Documented in the current ONLYOFFICE Spreadsheet Editor help; no final working-version endpoint is established.
• Scope: Docs and Desktop Editors release separately. This unversioned help does not establish availability in every older build, mobile client or deployment.
• Checked: October 14, 2026, against the official function reference. Documentation check; not a new native test.

RRI estimates the equivalent per-period compound growth rate of a lump sum, not a stream of monthly deposits. Set the period count to match the question: five years returns an annual rate; 60 months returns a monthly rate. A growth factor below 1 yields a negative mathematical rate, while an unchanged value yields zero.

=RRI(nper, pv, fv)

All listed arguments are required; the official reference does not specify an omitted-argument default. Enter all parameters in the order shown. Do not type the argument placeholders literally.

Documented vendor-specific note: The ONLYOFFICE help page states the purpose and names three required arguments. It does not document defaults, exact out-of-domain errors, or historical version-specific behavior. For the worked real-number cases, we use positive initial and ending values and positive nper.

Independent mathematical model: r = (fv/pv)^(1/nper) − 1. Independent check: pv × (1+r)^nper = fv (to numerical precision). This is an explanatory calculation model and is not an assertion about native error handling.

1. Start a blank workbook in ONLYOFFICE Spreadsheet Editor and select an empty sheet. Use English formula names for the displayed examples.
2. Enter the following input cells exactly. Plain numeric values are numeric entries; percentage entries like 8% are numeric percentages, not quoted strings.
3. Enter the first formula in the worked-example table into a blank output cell, such as H2, unless the setup names a particular output cell. Avoid overwriting the input ranges.
4. Press Enter. Increase displayed precision to at least six decimal places or use Percent formatting where the answer is a rate. Compare with the independently calculated expected result.
5. For the remaining rows, place each formula in a fresh blank output cell (H3, H4, and so on). Cells/ranges in the sample setup remain fixed unless an example explicitly uses different literal arguments.

Baseline interpretation: =RRI(B2,B3,B4) gives the constant annual compound growth rate needed to take 1000 to 1500 over 5 years, assuming no intermediate deposits or withdrawals. The reconstruction in D3 makes the assumption auditable.

The expected result uses a decimal number with six digits after the decimal point (half-up rounding). A rate shown as 0.060000 is 6% when displayed as a percentage. Results are mathematical expectations from a 60-digit Decimal calculation checked with a separate floating-point implementation; no formula was executed inside ONLYOFFICE.

Calculate a CAGR-style return for one investment

For an investment worth 1000 initially and 1500 after five equal years, enter the values in B2:B4. =RRI(5,1000,1500) expresses an annualized rate because the time input is in years. To represent 60 monthly periods instead, pass 60; the answer becomes a monthly rate, which cannot be compared directly to an annual return without consistent compounding.

Separate total return from annual return

(fv-pv)/pv is the simple total return over the whole interval. RRI finds the per-period compound equivalent, which is lower than the total return across many periods. Show both in a dashboard and label the units explicitly.

Sanity-check an end value

Use =B3*(1+D2)^B2 beside the RRI result to reconstruct the ending investment value. When the reconstructed value differs materially, check that the original opening/closing amounts match the intended time interval and that no additional contributions occurred.

Relate to PDURATION (a different question)

RRI solves for the rate when periods are known; PDURATION solves for the period count when a positive rate and values are known. For positive growth, substituting the RRI result into PDURATION should recover the starting period count mathematically.

Additional validation and edge-case checklist

• Confirm the valuation dates; a half-year should not be described as a full year.
• RRI is not a substitute for IRR/XIRR when dated intermediate cash flows exist.
• If a final value incorporates dividends/distributions, specify whether they were reinvested.

Error handling: The vendor reference does not list every invalid-input result. Diagnose an actual error using the entered values and installed build rather than importing an error rule from another spreadsheet.

The examples use English function names, decimal points and comma argument separators, matching the function-entry guide. Adapt notation to the installed formula-language and region settings. When moving a workbook between products, recalculate the small sample in the destination version before trusting the full model. Display precision is separate from the stored value; retain unrounded intermediate values when reconciling totals.

• ONLYOFFICE RRI function reference: purpose, syntax and argument meanings.
• Spreadsheet Editor formula entry: function catalog and English entry syntax.
• Docs release history and Desktop Editors release history: separate product timelines.

• ROUND: choose displayed calculation precision
• IF: validate a worksheet condition