XIRR in Excel 2004?

K

Keys88

How can XIRR be done in Excel 2004 for Mac (v. 11.0)?

XIRR is not listed in the built-in Functions dialog. Is there
an equivalent function in Mac XC 2004/v11?

Thank you.
 
M

Mike Middleton

Keys88 -

For pre-Mac-2008 and pre-Windows-2007, the XIRR function is part of the
Analysis ToolPak add-in.

To see whether it's installed, check the Mac Excel 2004 Tools menu to see if
there's a Data Analysis item. If not, check Tools | Add-ins to see if
Analysis ToolPak is listed. If so, check the box and click OK. If it's not
listed, install it from the Excel/Office CD.

- Mike
http://www.MikeMiddleton.com
 
Top