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.
 
Search JabSto ::




Custom Search