formulastreak

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.

Leaf & Loam orders · edit I2 and watch it recalculate
Click a cell (or use the arrow keys) to insert its address · Enter shows the resultI2 = $38.95
ABCDEFGHI
1OrderDateCustomerProductCategoryQtyPriceStatusTo pay
210012 Mar 2026Mara OkaforMonsteraPlants1$34.00Shipped$38.95
310022 Mar 2026Jonas LindTerracotta potPots3$12.50Shipped$42.45
410033 Mar 2026Priya RamanSnake plantPlants2$22.00Shipped$48.95
510044 Mar 2026Tomás RuizWatering canTools1$18.00Pending$22.95
610055 Mar 2026Elif DemirFernPlants4$9.50Shipped$42.95
710065 Mar 2026Mara OkaforPotting mixSoil2$7.25Returned$19.45
810076 Mar 2026Kenji MoriPruning shearsTools1$24.00Shipped$28.95
910087 Mar 2026Ines VargaCeramic potPots2$19.00Pending$42.95
1010098 Mar 2026Jonas LindMonsteraPlants1$34.00Shipped$38.95
1110109 Mar 2026Sofia RossiFernPlants6$9.50Shipped$57.00
12101110 Mar 2026Priya RamanPotting mixSoil5$7.25Shipped$41.20
13101211 Mar 2026Leo BrandtSnake plantPlants1$22.00Pending$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.

Leaf & Loam orders · edit I2 and watch it recalculate
Click a cell (or use the arrow keys) to insert its address · Enter shows the resultI2 = $36.72
ABCDEFGHI
1OrderDateCustomerProductCategoryQtyPriceStatusWith tax
210012 Mar 2026Mara OkaforMonsteraPlants1$34.00Shipped$36.72
310022 Mar 2026Jonas LindTerracotta potPots3$12.50Shipped$40.50
410033 Mar 2026Priya RamanSnake plantPlants2$22.00Shipped$47.52
510044 Mar 2026Tomás RuizWatering canTools1$18.00Pending$19.44
610055 Mar 2026Elif DemirFernPlants4$9.50Shipped$41.04
710065 Mar 2026Mara OkaforPotting mixSoil2$7.25Returned$15.66
810076 Mar 2026Kenji MoriPruning shearsTools1$24.00Shipped$25.92
910087 Mar 2026Ines VargaCeramic potPots2$19.00Pending$41.04
1010098 Mar 2026Jonas LindMonsteraPlants1$34.00Shipped$36.72
1110109 Mar 2026Sofia RossiFernPlants6$9.50Shipped$61.56
12101110 Mar 2026Priya RamanPotting mixSoil5$7.25Shipped$39.15
13101211 Mar 2026Leo BrandtSnake plantPlants1$22.00Pending$23.76

Names that read like a sentence

Good names make the logic obvious at a glance, even months later.

March household budget · edit E2 and watch it recalculate
Click a cell (or use the arrow keys) to insert its address · Enter shows the resultE2 = 0%
ABCDE
1CategoryTypeBudgetActualOver by
2RentFixed$1,200.00$1,200.000%
3GroceriesVariable$450.00$512.4014%
4UtilitiesFixed$160.00$148.750%
5TransportVariable$120.00$96.500%
6Phone & internetFixed$65.00$65.000%
7Eating outVariable$150.00$203.1035%
8SubscriptionsFixed$38.00$44.9718%
9GymFixed$40.00$40.000%
10GiftsVariable$60.00$25.000%
11SavingsFixed$300.00$300.000%

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
Select I2 and type = to start its formula (in the cell or the formula bar)
ABCDEFGHIJKL
1OrderDateCustomerProductCategoryQtyPriceStatusTo payFree from$50.00
210012 Mar 2026Mara OkaforMonsteraPlants1$34.00ShippedShipping$4.95
310022 Mar 2026Jonas LindTerracotta potPots3$12.50Shipped
410033 Mar 2026Priya RamanSnake plantPlants2$22.00Shipped
510044 Mar 2026Tomás RuizWatering canTools1$18.00Pending
610055 Mar 2026Elif DemirFernPlants4$9.50Shipped
710065 Mar 2026Mara OkaforPotting mixSoil2$7.25Returned
810076 Mar 2026Kenji MoriPruning shearsTools1$24.00Shipped
910087 Mar 2026Ines VargaCeramic potPots2$19.00Pending
1010098 Mar 2026Jonas LindMonsteraPlants1$34.00Shipped
1110109 Mar 2026Sofia RossiFernPlants6$9.50Shipped
12101110 Mar 2026Priya RamanPotting mixSoil5$7.25Shipped
13101211 Mar 2026Leo BrandtSnake plantPlants1$22.00Pending

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.

Practise it now