Lesson 28 of 45, Dynamic arrays
LET
Quick answer
Name the pieces of a long formula.
- Key formula
=LET(subtotal,B2*C2,subtotal*1.08)(One name)
Watch it done
2 stepsWatch the technique worked out on sample data, then try it yourself in the exercises.
How it works
=LET(name1, value1, [name2, value2, …], result) assigns names inside a formula. Each name is calculated once and can use the names before it.
Long formulas become readable and faster to debug, and you stop repeating the same sub-calculation three times.
Syntax
=LET(subtotal,B2*C2,subtotal*1.08)One name=LET(subtotal,B2*C2,discount,IF(subtotal>=500,subtotal*0.1,0),subtotal-discount)Names that build on each otherWatch out for
- Names can't look like cell references: "tax1" is cell TAX1. Use names like taxRate.
- The last argument is always the result.
The exercises
- Discounted totals. In D2, use LET: subtotal = qty × price; if subtotal is $500 or more, take 10% off. Return the discounted total. Fill down to D6.
- Quiz status. In E2, use LET to name the average of the three quizzes, then return Honors (85+), Pass (70–84.99) or Retake. Fill down to E6.
Questions people ask about this
Updated Checked by running: every exercise answer on this page was graded by our formula engine on .
Graded practice for this lesson is part of Pro
The walkthrough and notes are open to everyone. Pro unlocks the exercises here and in the other 43 Pro lessons, Excel and Google Sheets, 125 exercises in all.
- Discounted totals
- Quiz status