finance functions not available

[Ivanl]

Hello,

I have added the analysis toolpack in my excel 2003, but some of the finance
functions (E.g. coupdays, couppcd, etc) do not respond as functions. In
other words, when I type =coupdays( excel does not see it as a function.

what could the problem be?

Thanks.

I.

 

[Peo Sjoblom]

Are you saying that some works?

What do you get when you type

=WORKDAY(TODAY(),10)

and what do you get when you use COUPDAYS?

if you get name errors for both I suspect you ATP installation failed, it
can be a nuisance at times to fix this when Excel thinks it is installed but
it doesn't work

 

[Ivanl]

August 7, 2007.

coupdays does not show up as a function. When I type =coupdays() it does
not ask for any inputs into the function. It does not pick it up as a
function at all.

Funny thing is I really need the coupon functions and functions relating to
fixed income right now.

 

[Peo Sjoblom]

So what do you get in the cell? Just the text string of the formula? If
that's the case,
change the format of the cell to general, double click the cell (or press
F2) and press enter

 

[Gord Dibben]

That is the behaviour of the ATP functions......................no tool tips.

Enter =COUPDAYS() then click on the Fx icon to get a list of arguments to fill
in.

Or hit the Fx icon and choose COUPDAYS from the Financial category.


Gord Dibben MS Excel MVP

 

[Ivanl]

hello Peo and Gord,

Thanks for the help.

That is the behaviour of the ATP functions......................no tool tips.

Enter =COUPDAYS() then click on the Fx icon to get a list of arguments to fill
in.

Or hit the Fx icon and choose COUPDAYS from the Financial category.


Gord Dibben MS Excel MVP

 

[T. Valko]

Another way:

CTRL SHIFT A

Start typing the formula:

=COUPDAYS(

After you type in the "(" then use the key combo of CTRL SHIFT A and the
arguments will show. It doesn't work like the regular function tooltips,
though! In fact, it seems like a pita but at least it'll show you what the
arguments are supposed to be.

 

[Ivanl]

nice tip.

Another way:

CTRL SHIFT A

Start typing the formula:

=COUPDAYS(

After you type in the "(" then use the key combo of CTRL SHIFT A and the
arguments will show. It doesn't work like the regular function tooltips,
though! In fact, it seems like a pita but at least it'll show you what the
arguments are supposed to be.

 

[Gord Dibben]

Good trick Biff

Not knowing that one before now.


Gord