◄Syntax►  ◄Details►  ◄Example►                 ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
IRR# (valuearray#(), valuecount%, guess#, status%)
 
    ■ valuearray#()     An array of cash flow values.
    ■ valuecount%       The total number of items in the cash flow
                        array.
    ■ guess#            A value you guess is close to the result of IRR#.
    ■ status%     A variable that returns a value indicating calculation
                  failure or success: 0 = success; 1 = failure.
 
Returns
    The internal rate of return for a series of periodic cash flows
    (payments and receipts).
 
See Also    ◄MIRR#►    ◄NPV#►    ◄Rate#►