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

Custom Search