Microsoft Office Tutorials and References
In Depth Information
Ways to Enter a Function into a Formula
Figure 4-4: The Insert Function dialog box.
When you select a category from the drop-down list, the list box displays the functions in the
selected category. The Most Recently Used category lists the functions that you’ve used most
recently. The All category lists all the functions available across all categories. Access this
category if you know a function’s name but not its category.
If you’re not sure which function to use, you can search for a function. Use the field at the top of
the Insert Function dialog box. Type one or more keywords and click Go. Excel then displays a list
of functions that match your search criteria. For example, if you’re looking for functions to
calculate a loan payment, type loan as the search term.
When you select a function in the Select a Function list box, notice that Excel displays the
function (and its argument names) in the dialog box, along with a brief description of what the
When you locate the function that you want to use, click OK. Excel’s Function Arguments dialog
box appears, as shown in Figure 4-5. Use the Function Arguments dialog box to specify the
arguments for the function. You can easily specify a range argument by clicking the Collapse Dialog
button (the icon at the right edge of each argument field). Excel temporarily collapses the
Function Arguments dialog box to a thin box, so that you can select a range in the worksheet.
Figure 4-5: The Function Arguments dialog box.