Datasheet

More argument entry boxes appear as you need them. First, though, how
do you enter the argument? There are two ways.
7. Enter the argument one of two ways:
• Type the numbers or cell references into the boxes.
• Use those funny-looking squares to the right of the entry boxes.
In Figure 1-22 two entry boxes are ready to go. To the left of them are the
names Number1 and Number2. To the right of the boxes are the little
squares. These squares are actually called
RefEdit controls. They make
argument entry a snap. All you do is click one, click the cell with the
value, and then press Enter.
8. Click the RefEdit control to the right of the Number1 entry box.
The Function Arguments dialog box shrinks to just the size of the entry
box.
9. Click the cell with the first number.
Figure 1-23 shows what the screen looks like at this point.
10. Press Enter.
The Function Arguments dialog box reappears with the argument entered
into the box. The argument is not the value in the cell, but instead is the
address of the cell that contains the value — exactly what you want.
11. Repeat Steps 7–9 to enter the other two cell references.
Figure 1-24 shows what the screen should now look like.
RefEdit controls
Figure 1-22:
Getting
ready to
enter some
arguments
to the
function.
32
Part I: Putting the Fun in Functions
05_046555 ch01.qxp 12/26/06 7:54 PM Page 32