Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / April 2006

Tip: Looking for answers? Try searching our database.

THE CUMIPMT() IS NOT PRESENT?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
EXCEL FINANCIAL - 18 Dec 2005 03:16 GMT
THE CUMIPMT() IS NOT PRESENT?
Gord Dibben - 18 Dec 2005 05:12 GMT
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 Tools>Add-ins dialog you may have to install it
from Add/Remove>Change in Control Panel.

Have your CD handy.

Gord Dibben Excel MVP

>THE CUMIPMT() IS NOT PRESENT?
EXCEL FINANCIAL - 20 Dec 2005 06:16 GMT
Thanks Gord. This was helpful.

> From Help on CUMIPMT.........
>
[quoted text clipped - 13 lines]
>
> >THE CUMIPMT() IS NOT PRESENT?
funckenpassportnetworkshit - 20 Apr 2006 23:54 GMT
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)

> Thanks Gord. This was helpful.
>
[quoted text clipped - 15 lines]
> >
> > >THE CUMIPMT() IS NOT PRESENT?
Harlan Grove - 21 Apr 2006 00:58 GMT
funckenpassportnetworkshit wrote...
>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)
...

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 > Add-Ins... to display the Add-Ins dialog. Is the Analysis
ToolPak checked?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.