Relative References

Part of the Formulas and Data Analysis section of Coddy's Excel journey. Lesson 1 of 28.

A relative reference moves by the same row and column offset when you copy a formula. Copying =B2*C2 from D2 to D3 produces =B3*C3. Each row can therefore calculate from its own inputs.

B3 contains 4, C3 contains 7.

Example: =B3*C3.

Row three multiplies its own quantity 4 by its own price 7.

When copying down one row, relative row numbers increase by one.

The practice sheet highlights cells where you should enter formulas. The same formulas must work when the tests replace the input data.

Challenge

Easy

Quantities are in B2:B4 and unit prices in C2:C4. Calculate each row total in D2:D4 by multiplying that row's quantity and price.

Enter formulas in the highlighted output cells: D2, D3, D4. Keep the supplied data and headings. Tests change input values, so use cell references instead of typing the sample answers. Use English function names and commas between arguments.

Try it yourself

Sheet1