Function Syntax not showing - xnpv

M

Mike

I have the Analysis Tookpak add-in and the xnpv function works
correctly. However, when I type it into the worksheet, Excel does not
show the correct syntax for reference as it does for other functions
(such as npv). E.g. when I type in a cell "=xnpv(", Excell will not
show the proper syntax - although it does when I go through Insert-
Function.

Is there a way to change this?
 
T

T. Valko

These are called function tool tips.

They don't work the same for functions in the ATP.

Start typing the formula:

=XNPV(

Then hit CTRL SHIFT A

After you type in the opening ( 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XNPV Function 1
NPV vs XNPV 6
XNPV function 2
NPV vs. XNPV 2
XNPV in VBA 2
Zero or negative rates and XNPV? 4
Problem with SET & REF function 0
XNPV Function for office 2004 for mac 1

Top