Autofill a Relative Reference

In the previous page we created an equation in Cell C6 and tested it. Please Autofill that equation to all of the dates in Column C.

 

3. Try This: Autofill a Relative Reference

Select Cell C6. Double Click the AutoFill handle in the lower right corner of the Cell.

 

What Do You See? The formula in Cell C6 will be copied to all of the dates in Column C. However, instead of copying $3.25, the price in Cell B1, Cell C10 says "Product" and Cell C11 says "Pigs."

 

What Else Do You See? The numbers in Column E also indicate a problem. The first equation in Cell E6 calculates correctly. 

 

#VALUE means the data doesn't make any sense: there may be a mismatch. In this example, Excel can't multiply Pigs*205 (Text times a Number).

 

Keep going...

 

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.3. Apply cell references in formulas: Relative Cell References