Array FunctionsAdvanced

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.

Interactive Spreadsheet

Read about LET

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of LET

0/3

The same formula in the other shapes it takes at work.

  1. Name a value so the formula reads like a sentence

    LET binds a name once and reuses it.

    CoreAdvanced
  2. LET with two names, one built from the other

    A later name can use an earlier one.

    Intermediate
  3. LET to name a value used twice

    Calculate the average once, then use it by name.

    Advanced

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.

7 rows × 3 columns1 cell you fill in
ABC
1DealValueCommission
2Alders renewal4200
3Brant expansion3100
4Corvo new5800
5Delta renewal2400
6Ekko new4900
7Fenn expansion3600

Functions used here

What this exercise teachesMay contain 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.