Microsoft Office Tutorials and References

In Depth Information

Often, using arrays can help simplify your formula. The following formula, for example, returns the same result

as the previous formula but uses nested IF functions instead of an array:

=IF(A1=1,TRUE,IF(A1=3,TRUE,IF(A1=5,TRUE,FALSE)))

Ways to Enter a Function into a Formula

You can enter a function into a formula by typing it manually, by using the Function Library commands or by

using the Insert Function dialog box.

Entering a function manually

If you're familiar with a particular function — that is, you know its correct spelling and the types of arguments

that it takes — you may choose to simply type the function and its arguments into your formula. Often, this

method is the most efficient.

Excel 2007 introduced a handy Formula AutoComplete feature. When you type an equal sign and the first letter

of a function in a cell, Excel displays a drop-down list box of all the functions that begin with that letter and a

ScreenTip with a brief description for the function (see Figure 4-1). You can continue typing the function to

limit the list or use the arrow keys to select the function from the list. After you select the desired function,

press Tab to insert the function and its opening parenthesis into the formula.

Figure 4-1:
When you begin to type a function, Excel lists available functions that begin with the typed letters.