If XIRR was returning #NUM, I'd check on the iterations. But as your error
is #N/A, it has nothing to do with iterations.

I can only reiterate what I said in the first post. The only reason I know
of for XIRR to return #N/A is bad input data (ie, one of the cells in either
the date or value range is #N/A). If you're sure both of your data ranges
have no #N/A's in them, I have no futher suggestions.

Fred.

"Terry McCoy" wrote in message
...
Fred - Thanks for taking the time to respond to my question. The formulas
don't have any of the issues you mention. My calculations are set to 100
iterations, I have had problems in older versions of excel that were
corrected by lowering the iterations. Do you think that could be the
issue?

"Fred Smith" wrote:

XIRR is part of Excel 2007, so you don't have to install anything extra.
Besides if Excel didn't recognize the function, it would return #NAME
rather
than #N/A.

The only reason I know of for returning #N/A is if you have #N/A as one
of
the values or dates. Are you sure all the data is correct?

Maybe it's a recalculation problem. Do you have recalculation set to
manual,
and it's being recalculated only on save?

Do you have any of your dates dynamic (ie, based on, for example Today())
which would force a recalculation every time you open the file?

If none of these suggestions help, then post an example of your formula
and
data so we can investigate it further.

Regards,
Fred.

"Terry McCoy" <Terry wrote in message
...
I have an issue with the XIRR and XNPV functions in Excel 2007. The
formulas
seem to be operating properly, but when I go back into the spreadsheet
after
closing it, the cells where the formulas were now say #N/A. I have not
made
any changes to the spreadsheet. I do not have the analysis toolpak
checked
on the add-ins, but I understand that these functions are integral to
Excel
2007, so I should not need the toolpak. I would appreciate any help
anyone
can give me with this issue. Thanks,

Terry McCoy