Array Functions
Intermediate

LET with two names, one built from the other

A later name can use an earlier one.

Task:

Each invoice line needs its gross amount: net plus 20% VAT. In C2:C6 use LET to name the net amount, then name the VAT calculated from it, and return their sum.

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.

    Core
    Advanced
  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.

6 rows × 3 columns5 cells you fill in
ABC
1LineNetGross
2L1250
3L289.5
4L31200
5L415
6L5640
What this exercise teachesMay contain the answer

The final expression, net+vat, reads like the sentence that describes it. Names are evaluated in order, so each can build on the ones before — the same way you would set out the working on paper.