◄Syntax►  ◄Details►  ◄Example►                 ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
Rate# (nper#, pmt#, pv#, fv#, type%, guess#, status%)
 
    ■ nper#      The number of payment periods in the annuity.
    ■ pmt#       The payment to be made each period.
    ■ pv#        The present value.
    ■ fv#        The future value.
    ■ type%      An integer expression: 0 = end-of-period payment;
                                        1 = beginning-of-period payment.
    ■ guess#     A value you guess is close to the result of Rate#.
    ■ status%    A variable that returns a value indicating calculation
                 failure or success: 0 = success; 1 = failure.
 
Returns
    The interest rate per period for an annuity.
 
See Also    ◄FV#►    ◄IPmt#►    ◄NPer#►    ◄PPmt#►    ◄Pmt#►    ◄PV#►