Microsoft Office Tutorials and References
In Depth Information
Creating an Absolute Reference in a Formula
Note
Calculation Precedence In a formula, Excel performs multiplication
and division before addition and subtraction unless you use parentheses
to indicate calculation precedence. For example, Excel calculates the
formula =A4+B4*C4 in a different order than =(A4+B4)*C4. In the
first formula, Excel multiplies B4 by C4 and then adds A4. In the
second formula, Excel adds A4 and B4 and then multiplies it by C4.
Creating an Absolute Reference in a Formula
Sometimes when you copy a formula, you don’t want one of the cell references to change.
That’s when you need to create an absolute reference. You use the dollar sign (\$) to indic-
ate an absolute reference.
Type the equal ( = ) sign in the cell where you want to place the formula an-
swer.
Type the reference to the first cell of the formula. If this reference is to be
an absolute reference, add dollar signs ( \$ ) in front of both the column refer-
ence and the row reference.
Type the operator.
Type the reference to the second cell of the formula. If this reference is to
be an absolute reference, add dollar signs ( \$ ) in front of both the column
reference and the row reference.
Search JabSto ::

Custom Search