Forum Discussion
Num error using XIR
Hello, Attached is a workbok with 2 examples using XIR function. To calculate internal rate of return. One returns #NUM error. What is the reason for that? Best regards Geir
Thank you, I read that article. And I can not see that is one of those, it might be my "Inncorecct guess". I also got #NUM error if the number of columns for dates and values wa different.
I guess first value shall be negative (or missed)
That might be a solution. It worked if I changed my first value to a negative number. It also worked if I expanded my data area with more negative columns. I made a random calculator, to check the pattern. But still confused.