Expression Language Reference
    Preparing search index...

    Function MIRR

    • Returns the internal rate of return where positive and negative cash flows are financed at different rates.

      Category: Financial

      Parameters

      • values: any

        An array or a reference to values that contain numbers. These numbers represent a series of payments (negative values) and income (positive values) occurring at regular periods.

        • Values must contain at least one positive value and one negative value to calculate the modified internal rate of return. Otherwise, MIRR returns the #DIV/0! error value.
        • If an array or reference argument contains text, logical values, or empty values, those values are ignored; however, values with the value zero are included.
      • finance_rate: any

        The interest rate you pay on the money used in the cash flows.

      • reinvest_rate: any

        The interest rate you receive on the cash flows as you reinvest them.

      Returns number | Error

    Settings

    Member Visibility