Thread: THE CUMIPMT() IS NOT PRESENT?

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

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 <816A78AE-510E-487F-B410-D378084275C8@microsoft.com>,
EXCEL FINANCIAL <EXCEL FINANCIAL@discussions.microsoft.com> wrote:

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

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 <816A78AE-510E-487F-B410-D378084275C8@microsoft.com>,
> EXCEL FINANCIAL <EXCEL FINANCIAL@discussions.microsoft.com> wrote:
>
> > THE CUMIPMT() IS NOT PRESENT UNDER FINANCIAL FUNCTIONS UNDER EXCEL. WHAT
> > SHOULD I DO?
>