writer
5,435
edits
Changes
→Description
*This function computes the internal rate of return for a schedule of cash flows that is not essentially periodic.
*This function computes the internal rate of return for a schedule of cash flows that is not essentially periodic.
*This function suppose at least one positive cash flow and one negative cash flow.
*This function suppose at least one positive cash flow and one negative cash flow.
*The numbers in dates should be valid dates.
*In most cases no need to provide guess
XIRR shows the error value:
1.whenever any number in dates precedes the starting date or values
2.<math>Dates</math> contain a different number of values.
==Example==
XIRR(V, dates, G)
XIRR(V, dates, G)