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.