EOMONTH can now work with non-integer values like in Excel.
XIRR now returns an error like in Excel when it cannot converge.
The NPV would return other values in excel under some edge cases. The IRR function would fail under some edge cases since it uses the NPV function.
EOMONTH can now work with non-integer values like in Excel.
XIRR now returns an error like in Excel when it cannot converge. The NPV would return other values in excel under some edge cases. The IRR function would fail under some edge cases since it uses the NPV function.