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).