Microsoft Office Tutorials and References

In Depth Information

**Function entry tips**

Yet another way to insert a function while you’re entering a formula is to use the Function List to the left of the

Formula bar. When you’re entering or editing a formula, the space typically occupied by the Name box displays a

list of the functions you’ve used most recently. After you select a function from this list, Excel displays the Function

Arguments dialog box.

Function entry tips

Here are some additional tips to keep in mind when you use the Insert Function dialog box

to enter functions:

You can use the Insert Function dialog box to insert a function into an

existing formula.
Just edit the formula and move the insertion point to the location at

which you want to insert the function. Then open the Insert Function dialog box

(using any of the methods described earlier) and select the function.

■

You can also use the Function Arguments dialog box to modify the arguments for

a function in an existing formula.
Click the function in the Formula bar and then

click the Insert Function button (the
fx button, to the left of the Formula bar).

■

If you change your mind about entering a function, click the Cancel button.

■

The number of boxes you see in the Function Arguments dialog box depends on

the number of arguments used in the function you selected.
If a function uses

no arguments, you won’t see any boxes. If the function uses a variable number of

arguments (such as the
AVERAGE
function), Excel adds a new box every time you

enter an optional argument.

■

As you provide arguments in the Function Arguments dialog box, the value of

each argument is displayed to the right of each box.

■

A few functions, such as INDEX, have more than one form.
If you choose such

a function, Excel displays another dialog box that lets you choose which form you

want to use.

■

As you become familiar with the functions, you can bypass the Insert

Function dialog box and type the function name directly.
Excel prompts you

with argument names as you enter the function.

■

Editing Formulas

After you enter a formula, you can (of course) edit that formula. You may need to edit a

formula if you make some changes to your worksheet and then have to adjust the formula

to accommodate the changes. Or the formula may return an error value, in which case you

need to edit the formula to correct the error.