Microsoft Office Tutorials and References
In Depth Information
To Enter Formulas Using Point Mode and Determine Totals in the Template
3
•
Select cell F5, type
=
to start the
formula, click cell B5, type
*
(aster
isk), click cell E5, and then click the
Enter box in the formula bar to
display the formula =B5*E5 in the
formula bar and the value 3.45
(1 x 3.45) as the total value in
cell F5 (Figure 6–11).
formula assigned
to cell F5
value of 1 3.45
appears in cell F5
Figure 6–11
4
•
Select cell G5, type
=
to start the
formula, click cell F5, type

(minus
sign), click cell D5, and then click
the Enter box in the formula bar
to display the formula =F5 – D5 in
the formula bar and the value 1.45
(3.45 – 2) as the proﬁ t potential in
cell G5 (Figure 6–12).
formula assigned
to cell G5
value of 3.45 – 2
appears in cell G5
Figure 6–12