Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Syntax not showing - xnpv
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Syntax not showing - xnpv
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. -- Biff Microsoft Excel MVP "Mike" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XNPV Function | Excel Worksheet Functions | |||
XNPV Function | Excel Discussion (Misc queries) | |||
Syntax for IF function | New Users to Excel | |||
A function to get a variable row reference for range in XNPV funct | Excel Worksheet Functions | |||
XNPV function | Excel Worksheet Functions |