Concept Flow
Length (A2) --->
Width (B2) ---> Area (C2)
The design intent is captured by constraining the Area to be the product of Length and Width. Changes in Length or Width automatically update the Area.
Length (A2) --->
Width (B2) ---> Area (C2)
=A2*B2This formula multiplies the Length value in cell A2 by the Width value in cell B2 to calculate the Area in cell C2.
| Step | Expression | Evaluates To | Explanation |
|---|---|---|---|
| 1 | A2 | 10 | Length value taken from cell A2. |
| 2 | B2 | 5 | Width value taken from cell B2. |
| 3 | =A2*B2 | 50 | Multiplying Length by Width to get Area. |
| Variable | Value | Source Cell |
|---|---|---|
| Length | 10 | A2 |
| Width | 5 | B2 |
| Area | 50 | C2 |
Pass the test and this pattern moves unknown