THE CUMIPMT() IS NOT PRESENT?

[EXCEL FINANCIAL]

THE CUMIPMT() IS NOT PRESENT?

 

[Gord Dibben]

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

 

[EXCEL FINANCIAL]

Thanks Gord. This was helpful.

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

 

[Harlan Grove]

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?

 

[CompuTec]

I also installed the ATP add-in, but I continue to receive #N/A error when I
use cumipmt calculation. Ideas? Thanks!

 

[Dave Peterson]

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.

 

[CompuTec]

You're brilliant! I left the ",0" (comma zero) off the end of the formula.
Now it works. Thanks!

 

[Dave Peterson]

Sometimes, just coming back after a break means you can find that typing error!

Glad you got it working.