IRR# Function
◄Summary► ◄Details► ◄Example► ◄Contents► ◄Index► ◄Back►
──────────────────────────────────────────────────────────────────────────────
Financial Functions available in Professional Edition only
──────────────────────────────────────────────────────────────────────────────
Returns the internal rate of return for a series of periodic cash flows
(payments and receipts). Requires FINANCE.QLB (FINANCE.LIB when compiling);
include FINANCE.BI.
IRR# (valuearray#(), valuecount%, guess#, status%)
■ valuearray#() Array of cash flow values
■ valuecount% Total number of items in the cash flow array
■ guess# Value you guess is close to the result of IRR#
■ status% Variable that returns a value indicating calculation
failure or success:
0 = success
1 = failure
See Also
◄Financial Function Summary► ◄$INCLUDE Metacommand► ◄Quick Libraries►