Array Functions
Advanced
Name a value so the formula reads like a sentence
LET binds a name once and reuses it.
Task:
This commission calculation repeats the same total three times, and nobody can read it. In C2, use LET to bind the name total to SUM(B2:B7), then return total multiplied by 0.05.
Learning Objectives:
- Bind a name with LET
- Put the calculation last
- Write formulas someone else can read
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Deal | Value | Commission |
| 2 | Alders renewal | 4200 | |
| 3 | Brant expansion | 3100 | |
| 4 | Corvo new | 5800 | |
| 5 | Delta renewal | 2400 | |
| 6 | Ekko new | 4900 | |
| 7 | Fenn expansion | 3600 |
What this exercise teaches (contains the answer)
LET is the closest Excel gets to a variable. It makes long formulas readable, and Excel evaluates each name once rather than every time it appears — so a formula repeating an expensive lookup five times gets faster as well as clearer.