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.
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,