Microsoft Office Tutorials and References

In Depth Information

**Adding Functions to a Formula**

Figure 11-7
The value to the right of each input box shows the actual value that will be used by

the formula based on your input. Below that column is the overall result of the formula.

TROUBLESHOOTING

An entry in the Function Arguments box shows as “Invalid”

When you ill in the blanks in the Function Arguments dialog box, you have the option

to type a formula containing any combination of constants, operators, cell or range

references, or names. If you enter a formula and Excel displays Invalid in bold red letters

to its right, check that you got all those elements correct. If the formula is otherwise

accurate, you probably added an equal sign at the beginning of the formula. The equal

sign is used only at the beginning of a cell, not for formulas used as arguments in a

function. Delete the equal sign, and the error should be replaced by a value.

The small button to the right of each input box collapses the dialog box temporarily so you

can select a cell or range to insert in that box. After you select an address, click the button

to expand the dialog box again.

Even when you type a formula directly in the formula bar (or in the cell itself), you get

some help. After you enter an equal sign and begin typing a letter or two, Excel displays a

list of all available functions that begin with that combination. As you type, the list narrows

further. You can use the down arrow at any time to move through the list, select a

function, and then press Tab to add it to the formula bar. When you do, the display beneath

the formula bar changes to show arguments for the selected function. In some cases (as in

the CONVERT function), one or more arguments might consist of a list of specific options,