Microsoft Office Tutorials and References
In Depth Information
How to Make Your Formulas Function Even Better
After you locate and select the function that you want to use, click the OK
button to insert the function into the current cell and open the Function
Arguments dialog box. This dialog box displays the required arguments for
the function along with any that are optional. For example, suppose that you
select the SUM function (the crown jewel of the Most Recently Used function
category) in the Select a Function list box and then select OK. As soon as you
do, the program inserts
SUM()
in the current cell and on the Formula bar (following the equal sign), and the
Function Arguments dialog box showing the SUM arguments appears on the
screen (as shown in Figure 2-15). This is where you add the arguments for the
SUM function.
As shown in Figure 2-15, you can sum up to 255 numbers in the Function
Arguments dialog box. What’s not obvious, however (there’s always some
trick, huh?), is that these numbers don’t have to be in single cells. In fact,
most of the time you’ll be selecting a whole slew of numbers in nearby cells
(in a multiple cell selection — that range thing) that you want to total.
Figure 2-15:
Specify the
arguments
to use in the
selected
function in
the Function
Arguments
dialog box.
To select your first number argument in the dialog box, you select the cell (or
block of cells) in the worksheet while the insertion point is in the Number1
text box. Excel then displays the cell address (or range address) in the
Number1 text box while, at the same time, showing the value in the cell (or
values, if you select a bunch of cells) in the box to the right. Excel displays
the total near the bottom of the Function Arguments dialog box after the
words Formula result=.
Search JabSto ::




Custom Search