Financial

RRI function

Equivalent interest rate for growth. RRI works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.

Syntax

=RRI(nper, pv, fv)
ArgumentUse
nperrequired
pvrequired
fvrequired

On live data

In Sheets, RRI sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.

See the integrations

Try it in a free calculator

CAGR calculatorWork out the compound annual growth rate between a start and end value over any number of years, check it with RRI, and project future values with the same rate..

More financial functions

PMTPeriodic payment of a loan or annuityACCRINTAccrued interest of a periodic-interest bondACCRINTMAccrued interest paid at maturityAMORDEGRCFrench degressive depreciation of a periodAMORLINCFrench linear depreciation of a periodCOUPDAYBSDays from coupon period start to settlementCOUPDAYSDays in the coupon period of settlementCOUPDAYSNCDays from settlement to the next couponCOUPNCDNext coupon date after settlementCOUPNUMCoupons payable up to maturityCOUPPCDPrevious coupon date before settlementCUMIPMTInterest paid between two periods

All 55 financial functions →

Spreadsheet formulas on live business data

Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.

See the integrations