SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / RRI
In This Topic
    RRI
    In This Topic

    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