Why Doesn't XIRR work?

D

Don Stowell

I am trying to use the function XIRR and it won't work; I get #NAME? as my
result. It doesn't appear that XIRR is in my excel program. I have Office
XP. What
can I do to get XIRR in my program?

Thanks much, Always my best and have an awesome rest of the week and your
life,

Don
 
G

Gilles Desjardins

Try Tools, Add-ins, Check Analysis tool pack. That should do it.

HTh

Gilles
 
R

Ron Rosenfeld

I am trying to use the function XIRR and it won't work; I get #NAME? as my
result. It doesn't appear that XIRR is in my excel program. I have Office
XP. What
can I do to get XIRR in my program?

Thanks much, Always my best and have an awesome rest of the week and your
life,

Don

Look at HELP for XIRR. It explains exactly the cause of this error message and
how to fix it.

--ron
 
Top