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