XIRR formula throws #NAME? error

[mmorin]

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?

[keme]

Looks like your locale setting dictates comma for decimal point, but the third (optional) parameter for “best guess” uses a period character.

Change 0.1 to 0,1 in your formula.

=XIRR(B1:B4;A1:A4;0,1)

[mmorin]

Yes, of course, thank you!