Microsoft Office Tutorials and References
In Depth Information
Creating Functions
Enter the cell addresses in the text boxes. Type them or click the Collapse Dia-
log button to the right of the text box, select the cell or range using your
mouse, and then click the Expand Dialog button.
Click OK .
For Your Information: Inserting Placeholder Arguments
If you don’t know the cell references you want to use for a function,
you can insert argument names as placeholders, and then fill in the
actual argument later. Press Ctrl+Shift+A after you type the functions
name. Excel uses the arguments names as arguments. For example,
=VLOOKUP(lookup_value,
table_array,
col_index_num,
range_lookup).
Search JabSto ::




Custom Search