Microsoft Office Tutorials and References
In Depth Information
LEARN R1C1 REFERENCES
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 .