software

THE CUMIPMT() IS NOT PRESENT?

From Help on CUMIPMT.........

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

Then it shows how if you don't know how.

Have a look.

If ATP is not avilable in the Toolsgt;Add-ins dialog you may have to install it
from Add/Removegt;Change in Control Panel.

Have your CD handy.Gord Dibben Excel MVP

On Sat, 17 Dec 2005 19:16:01 -0800, EXCEL FINANCIAL
gt; wrote:

gt;THE CUMIPMT() IS NOT PRESENT?

Thanks Gord. This was helpful.

quot;Gord Dibbenquot; wrote:

gt; From Help on CUMIPMT.........
gt;
gt; If this function is not available, and returns the #NAME? error, install and
gt; load the Analysis ToolPak add-in.
gt;
gt; Then it shows how if you don't know how.
gt;
gt; Have a look.
gt;
gt; If ATP is not avilable in the Toolsgt;Add-ins dialog you may have to install it
gt; from Add/Removegt;Change in Control Panel.
gt;
gt; Have your CD handy.
gt;
gt;
gt; Gord Dibben Excel MVP
gt;
gt; On Sat, 17 Dec 2005 19:16:01 -0800, EXCEL FINANCIAL
gt; gt; wrote:
gt;
gt; gt;THE CUMIPMT() IS NOT PRESENT?
gt;

I have the ATP installed and i still dont seem to have this cumipmt function.
(I also just did a repair on my office installation and it reported
everything was fine)

quot;EXCEL FINANCIALquot; wrote:

gt; Thanks Gord. This was helpful.
gt;
gt; quot;Gord Dibbenquot; wrote:
gt;
gt; gt; From Help on CUMIPMT.........
gt; gt;
gt; gt; If this function is not available, and returns the #NAME? error, install and
gt; gt; load the Analysis ToolPak add-in.
gt; gt;
gt; gt; Then it shows how if you don't know how.
gt; gt;
gt; gt; Have a look.
gt; gt;
gt; gt; If ATP is not avilable in the Toolsgt;Add-ins dialog you may have to install it
gt; gt; from Add/Removegt;Change in Control Panel.
gt; gt;
gt; gt; Have your CD handy.
gt; gt;
gt; gt;
gt; gt; Gord Dibben Excel MVP
gt; gt;
gt; gt; On Sat, 17 Dec 2005 19:16:01 -0800, EXCEL FINANCIAL
gt; gt; gt; wrote:
gt; gt;
gt; gt; gt;THE CUMIPMT() IS NOT PRESENT?
gt; gt;

funckenpassportnetwork**** wrote...
gt;I have the ATP installed and i still dont seem to have this cumipmt function.
gt;(I also just did a repair on my office installation and it reported
gt;everything was fine)
....

You may have the ATP files on disk, but are you loading the ATP in
Excel? Excel does *NOT* load the ATP by default. Run the menu command
Tools gt; Add-Ins... to display the Add-Ins dialog. Is the Analysis
ToolPak checked?