XIRR function on Excel 2003
 

Help suggests this XIRR function exists but i cant locate it

It's in the ATP.

<Tools <Add Ins,

And click on "Analysis ToolPak"
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Liz" wrote in message
...
Help suggests this XIRR function exists but i cant locate it

Go to ToolsAdd-ins and check the Analysis ToolPak add-in.

The XIRR Function will then be available.

BTW....Help on XIRR would have shown you the following.

Returns the internal rate of return for a schedule of cash flows that is not
necessarily periodic. To calculate the internal rate of return for a series of
periodic cash flows, use the IRR function.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.


Gord Dibben Excel MVP

On Sun, 24 Apr 2005 09:48:02 -0700, Liz wrote:

Help suggests this XIRR function exists but i cant locate it