XNPV function

[Jonathan Lomas]

I am using the XNPV function in office xp on my windows machine, but when I
open it on my mac, it gives the 'name?" error. Is there a way I can install
the XNPV & other financial functions in office 2004 for mac?

 

[Jim Gordon MVP]

Hi Jonathan,

Excel Mac supports the same financial functions as Excel Windows. In both
Mac and Windows you need to visit the Tools menu.

Choose Tools > Add-Ins then check the Analysis ToolPak options.

If you don't see Analysis ToolPak choices in the Add-Ins dialog box, then
you need to install them from the Install CD that came with Excel.

-Jim

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[JE McGimpsey]

I am using the XNPV function in office xp on my windows machine, but when I
open it on my mac, it gives the 'name?" error. Is there a way I can install
the XNPV & other financial functions in office 2004 for mac?

See one reply in microsoft.public.excel.worksheet.functions