Error Messages/41074

Error message examples

Initial guess for XIrr must be non-negative.


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.


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

See Also


You are not allowed to post comments.