Microsoft Office Tutorials and References

In Depth Information

**To Enter a Formula Containing Absolute Cell References**

2

•
Click the Enter box in the

formula bar to display the result,

1319724.83, in cell B5, instead of

the formula (Figure 3–26).

formula

assigned to cell

B5 appears in

formula bar

projected

January cost of

goods sold

Figure 3–26

3

•
Click cell B6, type
=
(equal sign),

click cell B4, type
—
(minus sign),

and then click cell B5.

•
Click the Enter box in the formula

bar to display the gross margin

for January, 2064184.99, in cell B6

(Figure 3-27).

formula

appears in

formula bar

active cell

shows result

of formula

Figure 3–27