finance functions not available

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
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
 
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
 
hello Peo and Gord,

Thanks for the help.

Gord Dibben said:
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
Click to expand...
 
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.
 
nice tip.

T. Valko said:
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.
Click to expand...
 
Back
Top