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




Custom Search