Error Messages/41074

Error message examples

Initial guess for XIrr must be non-negative.

Cause

XIrr calculates the internal rate of return for non-periodic cash flow given the cash flow and the dates of the cash flow. As the internal rate of return cannot be negative, the (optional) «guess» parameter provided to the XIrr function cannot be negative.

Please click on the following link for an example use of XIrr.

Remedies

Pass a positive value as the «guess» parameter to XIrr function.

See Also

• Function calls and parameters
• Function parameter qualifiers
• Financial functions: XIrr
• XIrr