Where to find XNPV and XIRR?

B

billbrandi

I'm using E 2003. I have a need to use the XNPV and XIRR functions but they
do not appear in my drop down list of functions. Are these functions that
need to be added to the standard menu of financial functions?

Thanks in advance,

Bill
 
M

Mike H

Hi,

You need to load the analysis toolpak

Tools|Addins - Check analysis toolpak
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
T

teylyn

You need to activate the Analysis ToolPak add-in for these functions
Tools - Add-Ins - tick Analysis ToolPak and hit OK.


I'm using E 2003. I have a need to use the XNPV and XIRR functions bu
they
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top