Microsoft Office Tutorials and References
In Depth Information
Using Mixed References to Combine Features of Relative and Absolute References
Using
Using Mixed
Mixed References
References tto Combine
Combine Features
Features oof Relative
Relative and
and Absolute
Absolute
References
References
In a number of situations, you might want to build a reference that has only
one dollar sign. For example, in Figure 8.8 , you want to use the monthly bonus
rate in row 3, but you want to allow the column to change. In this case, the
formula for cell B13 would be =B6*B\$3.
Figure 8.8.
Figure 8.8. By having the dollar sign before the 3 in C\$3, you lock the refer-
By having the dollar sign before the 3 in C\$3, you lock the refer-
ence to row 3 but allow the formula to point to columns D, E, and so on as
ence to row 3 but allow the formula to point to columns D, E, and so on as
you copy the formula.
you copy the formula.
When you copy this formula, it always points to the bonus amount in row 3,
but the remaining elements of the formula are relative. For example, the for-
mula in E15 is =E8*E\$3, which multiplies Dom s April sales by the April bo-
nus rate. Search JabSto ::

Custom Search