SpreadJS Documentation
RRI
SpreadJS Documentation > Formula Reference > Formula Functions > RRI

This function returns calculated interest rate for growth of investment.

Syntax

RRI(nper,pv,fv)

Arguments

This function has these arguments:

Argument Description
nper Number of periods for the investment
pv Present value of the investment
fv Future value of the investment

All the arguments of this function has positive values.

Remarks

If the passed arguments are invalid, this function returns an error value.

Data Types

Accepts numeric data. Returns numeric data.

Examples

RRI(96,10000,11000) gives the result 0.0009933