View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
JE McGimpsey
 
Posts: n/a
Default THE CUMIPMT() IS NOT PRESENT?

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

In article ,
EXCEL FINANCIAL <EXCEL wrote:

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