What do you get for =COUNT(B3:B56, A3:A56)? Since you seem to agree with all
other XIRR results, my guess is that in this case your "numbers" are text
instead of numbers, and therefore are ignored by the formula.

If COUNT returns 108, then you need to post the data before anyone can
comment intelligently.

Prior to 2007, XIRR was not a native Excel function. To use it, you had to
link in the Analysis ToolPak Add-In (ATPVBAEN.XLA). XIRR is a native
function in OpenOffice Calc, which cannot use the ATP add-in, hence the
perfectly predictable behavior that you describe between the two packages.

Jerry

"Howard Kaikow" wrote:

I just noticed a value of 0.000% for an annualized return computed using
XIRR in Excel 2003.
The probability of that result being correct is rather slim.

The formula used is =XIRR(B3:B56, A3:A56).
The problem appears to be caused by a Link.

If I instruct Excel to Open the Source for the link, the formula is
displayed as
=ATPVBAEN.XLA!XIRR(B3:B56, A3:A56)
If I open the workbook in Open Office's Calc, the formula is displayed as
=#NAME!XIRR(B3:B56; A3:A56)
If I remove the #NAME!, Calc seems to produce a plausible value.

There are over 100 XIRR functions in the workbook, thus far, this is the
only corrupt critter.

Looking back, I find a version of the workbook saved on 5 Jul 2008 did not
have this problem.
A workbook saved on 27 July 2008 does have the problem. I did not do any
Office Update in that interval.

How do I fix the Excel workbook?