Microsoft Office Tutorials and References

In Depth Information

**Using Mixed References**

Figure 3-8

A multiplication table using a mixed reference

original formula with

a mixed cell

reference that

multiplies the first

row by the first

column

formula copied to

the B3:F7 range with

mixed ranges to

multiply the first row

entries by the first

column entries

values returned by

each formula

Understanding When to Use Relative, Absolute, and Mixed References

Part of effective formula writing is knowing when to use relative, absolute, and mixed

references. Use relative references when you want to repeat the same formula with cells

in different locations on your worksheet. Relative references are commonly used when

copying a formula that sums a column of numbers or that calculates the cost of several

items by multiplying the item cost by the quantity being purchased.

Use absolute references when you want different formulas to refer to the same cell.

This usually occurs when a cell contains a constant value, such as a tax rate, that will be

used in formulas throughout the worksheet.

Mixed references are seldom used other than when creating tables of calculated

values such as a multiplication table in which the values of the formula or function can be

found in the initial rows and columns of the table.