Microsoft Office Tutorials and References
In Depth Information
Entering Formulas
3
Click the Enter box in
the formula bar and
then select cell H4 to
prepare to enter the
next formula.
formula appears
in formula bar
Type
=0.04* and
then click cell F4 to
add a cell reference
to the formula
(Figure 2 – 9).
value of formula .22 ×
(1337.625 – 1 * 24.32)
Enter box
marquee surrounds
selected cell F4
cell reference F4
appended to formula
Figure 2–9
Why should I use Point mode to enter formulas?
Using Point mode to enter formulas often is faster and more accurate than using the
keyboard to type the entire formula when the cell you want to select does not require you
to scroll. In many instances, as in these steps, you may want to use both the keyboard and
mouse when entering a formula in a cell. You can use the keyboard to begin the formula,
for example, and then use the mouse to select a range of cells.
4
Click the Enter box in
the formula bar and
then select cell I4 to
prepare to enter the
next formula.
formula assigned
to cell I4
Type
= (equal
sign) and then click
cell F4 to begin the
formula and add a
cell reference to the
formula.
value of formula
(.04 * 1337.625)
Type
–( (minus sign
followed by an open
parenthesis) and then
click cell G4 to add a
subtraction operator,
open parenthesis, and
cell reference to the
formula.
Net Pay formula
appears in cell I4
Figure 2–10
Type
+ (plus sign) and then click cell H4 to add an addition operator and cell reference to
the formula.
Type
) (close parenthesis) to complete the formula (Figure 2 – 10).
 
Search JabSto ::




Custom Search