I want to use XIRR to compute an internal rate of return and verify interest payments. I formatted dates as dates and numbers as numbers, included semicolons in the formula, and I am getting a #NAME?
error with no details.
Here are the data entries:
01-jun -11734,09
11-jun -1289,43
30-jun -504,12
01-jul 13532,92
=XIRR(B1:B4;A1:A4;0.1)
and here is a screenshot:
I have the latest LibreOffice, 7.0.3.1, on macOS 10.14.6.
How can I debug the error?