# LET (Excel lesson 28 of 45)

> Name the pieces of a long formula.

Source: https://spreadsheetpractice.com/learn/let-function · Updated October 29, 2026

- **Course:** [Excel course](https://spreadsheetpractice.com/learn), track "Dynamic arrays"
- **Time:** about 8 minutes, 2 graded exercises
- **Functions:** `LET`
- **Access:** Pro (the lesson text is free; the graded exercises need Pro)
- **Key formula:** `=LET(subtotal,B2*C2,subtotal*1.08)`: One name

## 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

| Formula | What it does |
|---|---|
| `=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 other |

## Watch 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

Solve them in the live grid at [LET](https://spreadsheetpractice.com/learn/let-function). Each answer is graded, then re-checked on changed data so typed-in numbers don't pass.

1. **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.
2. **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.

Previous: [FILTER](https://spreadsheetpractice.com/learn/filter-function) · Next: [SORTBY, TAKE & SEQUENCE](https://spreadsheetpractice.com/learn/sortby-take-sequence)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
