Microsoft Office Tutorials and References

In Depth Information

**LEARN R1C1 REFERENCES**

Part

I

Figure 48.
With R1C1, the formula is the same in each cell.

How about absolute references? In Figure 49, the formula
=F2*$M$1
ensures

that you always use the tax rate in cell M1. To specify an absolute reference

using R1C1, you leave off the square brackets. Cell
$M$1
is the 13th column

of row 1, so by using R1C13, you always point to M1.

Figure 49.
Absolute references in A1 style require dollar signs.

In Figure 50, the formula becomes
=RC[-4]*R1C13
.

Figure 50.
To specify an absolute value in R1C1, you omit the square

brackets. h e number now refers to a specii c row and column number.

Summary: R1C1-style referencing is not hard to learn and enables easier use

of
INDIRECT
.