B
Bob C
Nesting of functions works in Excel 2003 but the entering of nested functions
does not work the same as it does in Excel 2000. In Excel 2000 the entry of
a second (or lower) tier function can be done using the popup pull down
dialog that displays all available functions. In Excel 2003 attempting to
enter a second (or lower) tier function displays only the entry dialog for
the first tier function but the pop up pull down dialog for other functions
does not appear. The work around in Excel 2003 is to manually type the
function name with empty parentheses inside the first tier parentheses and
then the syntax help or sometimes the pull down dialog will show up when you
place the insertion point inside the empty parentheses for the lower tier
function. Another work around is of course to manually enter the entire
second tier function - but this requires remembering all of the syntax
details.
To see this work, simply try the same operation in Excel 2000 and Excel 2003
and the difference should be obvious.
does not work the same as it does in Excel 2000. In Excel 2000 the entry of
a second (or lower) tier function can be done using the popup pull down
dialog that displays all available functions. In Excel 2003 attempting to
enter a second (or lower) tier function displays only the entry dialog for
the first tier function but the pop up pull down dialog for other functions
does not appear. The work around in Excel 2003 is to manually type the
function name with empty parentheses inside the first tier parentheses and
then the syntax help or sometimes the pull down dialog will show up when you
place the insertion point inside the empty parentheses for the lower tier
function. Another work around is of course to manually enter the entire
second tier function - but this requires remembering all of the syntax
details.
To see this work, simply try the same operation in Excel 2000 and Excel 2003
and the difference should be obvious.