XIRR function
Posted by Philip Pallette on December 20, 2001 7:50 AM
The XIRR function fails to report a negative percentage when the internal rate of return on a column of numbers is indeed negative. Instead, the IRR reported is 0.0%
Any ideas?
Phil of Tech Support - TBG, New York
Posted by Joe Was on December 20, 2001 9:34 AM
The XIRR fuction requires that your column of data include both positive and negative values (at least one of each) or the results are unpredictable. In most cases the function issues a #NUM error if all the values are pos or neg. JSW
Posted by Joe Was on December 20, 2001 3:29 PM
You may need IRR and not XIRR
Your statement "when the internal rate of return on a column of numbers is indeed negative" if I understand you, may indicate that you are using the function incorrectly. The "X" in XIRR indicates that the data is irregular in period, therefore you cannot have a IRR of a column and be using XIRR. It needs the individual members of the column to work and not the result of that column. JSW
