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
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
Search JabSto ::

Custom Search