ExcelBanter - THE CUMIPMT() IS NOT PRESENT?

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - THE CUMIPMT() IS NOT PRESENT? (https://www.excelbanter.com/charts-charting-excel/60939-cumipmt-not-present.html)

EXCEL FINANCIAL

THE CUMIPMT() IS NOT PRESENT?

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

JE McGimpsey

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?

EXCEL FINANCIAL

THE CUMIPMT() IS NOT PRESENT?

This has helped. Thanks

"JE McGimpsey" wrote:

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?

All times are GMT +1. The time now is 08:08 PM.