◄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#►