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
 
Top