Page 100 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

9 RELATIVE & ABSOLUTE CELL

REFERENCES

Introduction

There are two types of cell references: relative and absolute. Relative and absolute references
behave differently when copied and filled to other cells. Relative references change when a formula

is copied to another cell. Absolute references, on the other hand, remain constant no matter where
they are copied.

Create and Copy a Formula Using Relative References

In the following example, we want to create a formula that will multiply each item's price by

the quantity. Instead of creating a new formula for each row, we can create a single formula in
cell D4 and then copy it to the other rows. We'll use relative references so the formula calculates
the total for each item correctly

1. Select the cell that will contain the formula. In our example, we'll select cell D4.

2. Enter the formula to calculate the desired value. In our example, we'll type =B4*C4.

91 | P a g e