Ask Your Question

XIRR formula throws #NAME? error

asked 2020-11-16 10:32:30 +0100

mmorin gravatar image

updated 2020-11-16 10:42:57 +0100

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


and here is a screenshot:

XIRR #NAME? error

I have the latest LibreOffice,, on macOS 10.14.6.

How can I debug the error?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-11-16 10:36:43 +0100

keme gravatar image

updated 2020-11-16 11:58:26 +0100

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.


edit flag offensive delete link more


Yes, of course, thank you!

mmorin gravatar imagemmorin ( 2020-11-19 14:30:21 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-11-16 10:32:30 +0100

Seen: 37 times

Last updated: Nov 16 '20