Spread.NET 17 Formula Reference
Formula Functions / Functions R to S / 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

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.