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.

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