Microsoft Office Tutorials and References
In Depth Information
Dealing with Function Arguments
Figure 80-2: The Function Arguments dialog box helps you enter arguments for a function.
In some cases, you might want to insert “dummy” arguments for a function — placeholders that
will be filled in later. This strategy is useful if you don’t yet know the cell references that will be
used. To insert argument names as placeholders, press Ctrl+Shift+A after you type the function’s
name. Excel uses the argument’s names as arguments. For example, if you press Ctrl+Shift+A
while entering the VLOOKUP function, Excel inserts the following:
=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
The formula, of course, returns an error, so you need to replace the dummy arguments with
actual values or cell references.
 
Search JabSto ::




Custom Search