THE CUMIPMT() IS NOT PRESENT?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Thanks Gord. This was helpful.

Gord Dibben said:
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
Click to expand...
 
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)
 
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)
Click to expand...
....

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?
 
I also installed the ATP add-in, but I continue to receive #N/A error when I
use cumipmt calculation. Ideas? Thanks!
 
That means your formula is bad (not the function call).

You may want to share your formula and if you use cell references in your
formula, share the values of those cells.
 
You're brilliant! I left the ",0" (comma zero) off the end of the formula.
Now it works. Thanks!
 
Sometimes, just coming back after a break means you can find that typing error!

Glad you got it working.
 
Back
Top