Microsoft Office Tutorials and References

In Depth Information

**Three Methods of Entering Formulas**

to offer B$2:B29 eventually. If you typed B2:B29, pressing F4 adjusts only

the B29 reference.

In this case, you need to click the insertion point just before, just after, or

in the middle of the characters B2 in the formula. If you then press F4, toggle

through the various dollar sign combinations on the B2 reference. Pressing

F4 twice results in the proper combination, as shown in
Figure 8.17
.

Figure 8.17.

Figure 8.17.
Using F4 is tricky when your reference is a rectangular

Using F4 is tricky when your reference is a rectangular

range
—
you must click into the formula.

range
—
you must click into the formula.

Three Methods of Entering Formulas

In the examples in the previous sections, you entered a formula by typing it.

You generally need to start a formula by typing the equal sign (or the plus

sign); after that point, you have three options:

•
Type the complete formula as described in the previous sections.

•
Type operator keys, but use the mouse to touch cell references. In

this topic, this is referred to as the mouse method.

•
Type the operator keys and then use the arrow keys to specify the

cell references by navigating to the cells. In this topic, this method is

referred to as the arrow key method.

Assume you would like to multiply the merchandise total in cell B2 by the

sales tax rate in cell F1, as shown in
Figure 8.18
.

Figure 8.18.

Figure 8.18.
You can use three methods to enter the formula

You can use three methods to enter the formula =B2*$F$1

=B2*$F$1..