Microsoft Office Tutorials and References

In Depth Information

**Knowing When to Use Mixed References**

Notice that both cell references are mixed. The reference to cell B3 uses an absolute reference for

the column ($B), and the reference to cell C2 uses an absolute reference for the row ($2). As a

result, this formula can be copied down and across, and the calculations are correct. For example,

the formula in cell F7 is

=$B7*F$2

If C3 used either absolute or relative references, copying the formula would produce incorrect

results.