The LET function
Updated · Works in: Excel 2021+, Microsoft 365, Google Sheets · Every example checked before release
Short answer
=LET(name, value, …, calculation) names parts of a formula so each is calculated once and the logic reads clearly, e.g. =LET(total,F2*G2,IF(total>=50,total,total+4.95)). Names can't look like cell addresses.
LET(name1, value1, [name2, value2, …], calculation) gives parts of a formula names. Each value is calculated once, and the final argument uses the names.
Name a repeated part
Without LET, a formula that uses F2*G2 three times calculates it three times and is hard to read. Name it once.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Product | Category | Qty | Price | Status | To pay |
| 2 | 1001 | 2 Mar 2026 | Mara Okafor | Monstera | Plants | 1 | $34.00 | Shipped | $38.95 |
| 3 | 1002 | 2 Mar 2026 | Jonas Lind | Terracotta pot | Pots | 3 | $12.50 | Shipped | $42.45 |
| 4 | 1003 | 3 Mar 2026 | Priya Raman | Snake plant | Plants | 2 | $22.00 | Shipped | $48.95 |
| 5 | 1004 | 4 Mar 2026 | Tomás Ruiz | Watering can | Tools | 1 | $18.00 | Pending | $22.95 |
| 6 | 1005 | 5 Mar 2026 | Elif Demir | Fern | Plants | 4 | $9.50 | Shipped | $42.95 |
| 7 | 1006 | 5 Mar 2026 | Mara Okafor | Potting mix | Soil | 2 | $7.25 | Returned | $19.45 |
| 8 | 1007 | 6 Mar 2026 | Kenji Mori | Pruning shears | Tools | 1 | $24.00 | Shipped | $28.95 |
| 9 | 1008 | 7 Mar 2026 | Ines Varga | Ceramic pot | Pots | 2 | $19.00 | Pending | $42.95 |
| 10 | 1009 | 8 Mar 2026 | Jonas Lind | Monstera | Plants | 1 | $34.00 | Shipped | $38.95 |
| 11 | 1010 | 9 Mar 2026 | Sofia Rossi | Fern | Plants | 6 | $9.50 | Shipped | $57.00 |
| 12 | 1011 | 10 Mar 2026 | Priya Raman | Potting mix | Soil | 5 | $7.25 | Shipped | $41.20 |
| 13 | 1012 | 11 Mar 2026 | Leo Brandt | Snake plant | Plants | 1 | $22.00 | Pending | $26.95 |
Several names, built step by step
Later names can use earlier ones: here tax uses total. Keep settings like a tax rate in a cell and lock it with $ ($L$1) so the formula still finds it when filled down.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Product | Category | Qty | Price | Status | With tax |
| 2 | 1001 | 2 Mar 2026 | Mara Okafor | Monstera | Plants | 1 | $34.00 | Shipped | $36.72 |
| 3 | 1002 | 2 Mar 2026 | Jonas Lind | Terracotta pot | Pots | 3 | $12.50 | Shipped | $40.50 |
| 4 | 1003 | 3 Mar 2026 | Priya Raman | Snake plant | Plants | 2 | $22.00 | Shipped | $47.52 |
| 5 | 1004 | 4 Mar 2026 | Tomás Ruiz | Watering can | Tools | 1 | $18.00 | Pending | $19.44 |
| 6 | 1005 | 5 Mar 2026 | Elif Demir | Fern | Plants | 4 | $9.50 | Shipped | $41.04 |
| 7 | 1006 | 5 Mar 2026 | Mara Okafor | Potting mix | Soil | 2 | $7.25 | Returned | $15.66 |
| 8 | 1007 | 6 Mar 2026 | Kenji Mori | Pruning shears | Tools | 1 | $24.00 | Shipped | $25.92 |
| 9 | 1008 | 7 Mar 2026 | Ines Varga | Ceramic pot | Pots | 2 | $19.00 | Pending | $41.04 |
| 10 | 1009 | 8 Mar 2026 | Jonas Lind | Monstera | Plants | 1 | $34.00 | Shipped | $36.72 |
| 11 | 1010 | 9 Mar 2026 | Sofia Rossi | Fern | Plants | 6 | $9.50 | Shipped | $61.56 |
| 12 | 1011 | 10 Mar 2026 | Priya Raman | Potting mix | Soil | 5 | $7.25 | Shipped | $39.15 |
| 13 | 1012 | 11 Mar 2026 | Leo Brandt | Snake plant | Plants | 1 | $22.00 | Pending | $23.76 |
Names that read like a sentence
Good names make the logic obvious at a glance, even months later.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Type | Budget | Actual | Over by |
| 2 | Rent | Fixed | $1,200.00 | $1,200.00 | 0% |
| 3 | Groceries | Variable | $450.00 | $512.40 | 14% |
| 4 | Utilities | Fixed | $160.00 | $148.75 | 0% |
| 5 | Transport | Variable | $120.00 | $96.50 | 0% |
| 6 | Phone & internet | Fixed | $65.00 | $65.00 | 0% |
| 7 | Eating out | Variable | $150.00 | $203.10 | 35% |
| 8 | Subscriptions | Fixed | $38.00 | $44.97 | 18% |
| 9 | Gym | Fixed | $40.00 | $40.00 | 0% |
| 10 | Gifts | Variable | $60.00 | $25.00 | 0% |
| 11 | Savings | Fixed | $300.00 | $300.00 | 0% |
Check yourself
One real exercise from the “LET and LAMBDA” unit. Checked on our server; no account needed.Orders under the amount in L1 pay the shipping fee in L2. Show each order's total including shipping in I2, using LET to name the order total (Qty × Price) and the shipping.
- Use LET
- No typed numbers
| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Product | Category | Qty | Price | Status | To pay | Free from | $50.00 | |
| 2 | 1001 | 2 Mar 2026 | Mara Okafor | Monstera | Plants | 1 | $34.00 | Shipped | Shipping | $4.95 | ||
| 3 | 1002 | 2 Mar 2026 | Jonas Lind | Terracotta pot | Pots | 3 | $12.50 | Shipped | ||||
| 4 | 1003 | 3 Mar 2026 | Priya Raman | Snake plant | Plants | 2 | $22.00 | Shipped | ||||
| 5 | 1004 | 4 Mar 2026 | Tomás Ruiz | Watering can | Tools | 1 | $18.00 | Pending | ||||
| 6 | 1005 | 5 Mar 2026 | Elif Demir | Fern | Plants | 4 | $9.50 | Shipped | ||||
| 7 | 1006 | 5 Mar 2026 | Mara Okafor | Potting mix | Soil | 2 | $7.25 | Returned | ||||
| 8 | 1007 | 6 Mar 2026 | Kenji Mori | Pruning shears | Tools | 1 | $24.00 | Shipped | ||||
| 9 | 1008 | 7 Mar 2026 | Ines Varga | Ceramic pot | Pots | 2 | $19.00 | Pending | ||||
| 10 | 1009 | 8 Mar 2026 | Jonas Lind | Monstera | Plants | 1 | $34.00 | Shipped | ||||
| 11 | 1010 | 9 Mar 2026 | Sofia Rossi | Fern | Plants | 6 | $9.50 | Shipped | ||||
| 12 | 1011 | 10 Mar 2026 | Priya Raman | Potting mix | Soil | 5 | $7.25 | Shipped | ||||
| 13 | 1012 | 11 Mar 2026 | Leo Brandt | Snake plant | Plants | 1 | $22.00 | Pending |
Common mistakes
Names that look like cell addresses (q3, tax1): they're read as references.
Forgetting the final calculation: LET needs an odd number of arguments.
Misspelling a name in the calculation: #NAME?.
Questions
Which versions have LET?+
Excel 2021, Excel 2024, Microsoft 365 and Google Sheets.
Does LET make formulas faster?+
Yes, when a part is reused: it's calculated once instead of every time it appears.
Reading is step one. Now make it stick.
Practise it in a five-minute lesson on a live sheet, with instant feedback. No account needed for the free units.