Microsoft Office Tutorials and References
In Depth Information
Entering Functions Using the Insert Function Dialog Box
Selecting a function that uses arguments
Most functions take arguments to provide the information the function needs
to perform its calculation. Some functions use a single argument; others use
many. Taking arguments and using arguments are interchangeable terms.
Most functions take arguments, but the number of arguments depends on the
actual function. Some take a single argument, and some can take up to 255.
The following example shows how to use the Insert Function dialog box to
enter a function that does use arguments. The example uses the PRODUCT
function. Here’s how to enter the function and its arguments:
1. Position the cursor in the cell where you want the results to appear.
2. Click the Insert Function button on the Ribbon.
Doing this opens the Insert Function dialog box.
3. Select Math & Trig in the Or select a category drop-down list.
4. Scroll through the Select a Function list until you see the PRODUCT
function and then click on it once.
Figure 2-6 shows what the screen now looks like.