Microsoft Office Tutorials and References

In Depth Information

**Ways to Enter a Function into a Formula**

When you type a function, Excel always converts the function’s name to uppercase.

Therefore, it’s a good idea to use lowercase when you type functions. If Excel doesn’t

convert your text to uppercase after you press Enter, your entry isn’t recognized as a

function — which means that you spelled it incorrectly or that the function isn’t

available. For example, it may be defined in an add-in that is not currently installed.

Using the Function Library commands

Another way to insert a function into a formula is to use the icons in the Formulas

➜

Function

Library group. Figure 4-3 shows these icons, each of which is a drop-down control.

When you select a function from one of these lists, Excel displays its Function Arguments dialog

box to help you enter the arguments. Refer to the next section for more information about the

Function Arguments dialog box.

Figure 4-3:
The icons in the Function Library group on the Formulas tab.

Using the Insert Function dialog box

The Insert Function dialog box provides a way to enter a function and its arguments in a

semiautomated manner. Using the Insert Function dialog box ensures that you spell the function

correctly and that it contains the proper number of arguments in the correct order.

To insert a function, select the function from the Insert Function dialog box, as shown in Figure

4-4. You access this dialog box by

h
Choosing Formulas

Function Library

Insert Function

➜

➜

h
Choosing Formulas

Function Library

AutoSum, and then clicking More Functions in the

➜

➜

drop-down list

h
Clicking the
fx icon to the left of the Formula bar

h
Pressing Shift+F3