0
0
Excelspreadsheet~10 mins

Table references in formulas in Excel - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table lists products with their prices and quantities. Column D will calculate the total cost per product using table references.

CellValue
A1Product
B1Price
C1Quantity
D1Total
A2Apple
B22
C25
D2
A3Banana
B31
C37
D3
A4Cherry
B43
C44
D4
Formula Trace
=[@Price]*[@Quantity]
Step 1: [@Price]
Step 2: [@Quantity]
Step 3: 2 * 5
Cell Reference Map
    A       B       C       D
1 |Product| Price |Quantity| Total |
2 | Apple |   2   |   5    |  ->  |
3 | Banana|   1   |   7    |      |
4 | Cherry|   3   |   4    |      |
The formula in column D uses structured references to the Price and Quantity columns in the same row.
Result
    A       B       C       D
1 |Product| Price |Quantity| Total |
2 | Apple |   2   |   5    |  10   |
3 | Banana|   1   |   7    |       |
4 | Cherry|   3   |   4    |       |
The Total column for Apple shows 10, which is Price times Quantity for that row.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does [@Price] mean in the formula?
AThe total of all Price values
BThe Price value in the first row
CThe Price value in the current row
DThe Price value in the last row
Key Result
Table structured references use [@ColumnName] to refer to the current row's value in that column.