LET function for named calculations in Excel - Cell-by-Cell Formula Trace

Sample Data

Two columns of numbers representing values for calculation.

Cell	Value
A1	10
A2	20
A3	30
B1	5
B2	15
B3	25

Formula Trace

=LET(x, A1+A2, y, B1+B2, x*y)

Step 1: x = A1 + A2

Step 2: y = B1 + B2

Step 3: x * y

Cell Reference Map

    A    B
1 | 10 |  5 |
2 | 20 | 15 |
3 | 30 | 25 |

Formula uses cells A1, A2, B1, and B2 for calculations.

Result

    A    B    C
1 | 10 |  5 | 600 |
2 | 20 | 15 |     |
3 | 30 | 25 |     |

Result 600 appears in cell C1 after evaluating the LET formula.

Sheet Trace Quiz - 3 Questions

What value does the name 'x' represent in the LET formula?

A 600

B 20

C 30

D 15

Key Result

LET assigns names to calculations and uses them in a final expression.