THE CUMIPMT() IS NOT PRESENT?

E

EXCEL FINANCIAL

THE CUMIPMT() IS NOT PRESENT UNDER FINANCIAL FUNCTIONS UNDER EXCEL. WHAT
SHOULD I DO?
 
J

JE McGimpsey

From XL Help ("CUMIPMT" topic):
Returns the cumulative interest paid on a loan from start_period to
end_period.
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.
Click to expand...

So load the ATP (Tools/Add-ins...)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cumipmt function / addins 1
How do I calculate total interest payments on a loan in a query? 1
Notes not showing up in Powerpoint Presenter Mode 0
CUMPRINC #NAME Error 1
THE CUMIPMT() IS NOT PRESENT? 7
Removing a repeated words 0
Excel Loan amortization Excel X for Mac 10.1.6 1
Result not less than 0 3

Top