Microsoft Office Tutorials and References
In Depth Information
Using mixed references
The easiest way to understand this concept is with an example. Figure 29-1 shows a simple
worksheet. The formula in cell D2 is
=(B2*C2)*$B$7
Figure 29-1: Formula references to the sales tax cell should be absolute.
This formula uses relative cell references (B2 * C2) and also an absolute reference to the sales tax cell
($B$7). This formula can be copied to the cells below, and all of the references will be correct. For
example, after copying the formula in cell D2, cell D3 contains this formula:
=(B3*C3)*$B$7
The references to the cells in columns B and C are adjusted, but the reference to cell B7 is not —
which is exactly what you want.
Using mixed references
In a mixed cell reference, either the column part or the row part of a reference is absolute (and
therefore doesn’t change when the formula is copied and pasted). Mixed cell references aren’t used often,
but as you see in this tip, in some situations, using mixed references makes your job much easier.
Here are two examples of mixed references:
=$A1
=A$1
Search JabSto ::




Custom Search