THE CUMIPMT() IS NOT PRESENT?

[Guest]

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

 

[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.

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

 

[Guest]

This has helped. Thanks

From XL Help ("CUMIPMT" topic):


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