Ask Your Question
0

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

    =XIRR(B1:B4;A1:A4;0.1)

and here is a screenshot:

XIRR #NAME? error

I have the latest LibreOffice, 7.0.3.1, 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
2

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.

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

edit flag offensive delete link more

Comments

Yes, of course, thank you!

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

Question Tools

1 follower

Stats

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

Seen: 37 times

Last updated: Nov 16 '20