### Using Reference Cells

The next
task is to calculate the daily sales. In this example, we will make
one Cell Reference in the formula Relative and the other Absolute.

**Before
You Begin: Edit the Data**

In Cell B2
type: 100

In Cell B3
type: 5

**
Thoughts to Consider**

Cell D6 is
the initial quantity sold.

Cell D7 should be whatever we sold on the first day, plus the
quantity we are forecasting for each day’s sales increment.

**6. Try it:
Create the Formulas**

Select
Cell D6 and
enter this equation:

=B2

Select Cell D7, and enter this equation:

=D6
+B3

**Try
This, Too: AutoFill the Formula**

Select **Cell D7** and double click the **AutoFill** handle to
fill down the formula. Keep
going...