Excel LET Function
Chala mitrano — lET lets you name a piece of a formula once and reuse it. Shorter formulas. Easier to read.
चला मित्रांनो — LET मध्ये सूत्रांचा तुकडा एकदा नाव देऊन पुन्हा वापरता येतो. वाचायला सोपे.
चलो दोस्तों — LET में सूत्र के टुकड़े को एक बार नाम देकर फिर उपयोग करते हैं। पढ़ना आसान।
Purpose
Store intermediate calculations in named variables inside one formula, then return a final result. Makes long formulas faster and clearer.
Return value
The value of the final calculation argument.
Syntax
Arguments
| Argument | Required? | Description |
|---|---|---|
name1 | Required | First variable name (no spaces). |
value1 | Required | Value or expression for that name. |
name2, value2, … | Optional | More name/value pairs. |
calculation | Required | Final expression using those names (last argument). |
Version
Microsoft 365 and Excel 2021. Pair with LAMBDA for custom functions.
How to use — Why → What → How
Why: The same VLOOKUP or FILTER range is typed three times. One typo breaks the sheet. LET names it once.
What: You alternate name, value, name, value, then a final calculation that uses the names.
How — numbered steps:
- Click the result cell.
- Type =LET(
- Type a name (example: total), comma, then the expression (example: SUM(D2:D20)).
- Add more pairs if needed.
- End with the final calculation (example: total*1.18) and press Enter.
Ravindra Bagale's Tip
Friends, names inside LET are not workbook names. They live only inside that formula.
Ravindra Bagale's Tip – मराठी
मित्रांनो, LET मधील नावे फक्त त्या सूत्रात राहतात — Name Manager नव्हे.
Ravindra Bagale's Tip – हिंदी
दोस्तों, LET के नाम सिर्फ उसी सूत्र में रहते हैं — Name Manager नहीं।
Worked examples
1) Name a sum, then add GST
Ravi Kulkarni’s Bhiwandi pick list: quantities in D2:D4 are 10, 4, 6.
Result: 23.6
What it means: total is 20; final calculation multiplies by 1.18.
2) Two names — net after discount
List price ₹1,500, discount 12%.
Result: 1320
What it means: price and disc are stored; last argument returns the net.
3) Reuse a long lookup once
Imagine a heavy XLOOKUP stored as city, then tested.
Result: MH warehouse
What it means: In real sheets, replace "Nashik" with an XLOOKUP — still calculated once.
4) Euro spare part (€)
Sofia Keller in Berlin: unit €18.40 × 5, then 5% handling.
Result: 96.6
What it means: Three named steps keep the formula readable.
5) Text + number together
Result: Boxes: 3
What it means: Final calculation can return text.
Common errors and fixes
Related functions
LAMBDA, IF, XLOOKUP, FILTER, MAP
Practice tasks (10)
- Task 1. LET that names total as 25+30 and returns total.Hint: last argument can be just total
- Task 2. Name price 200 and tax 0.18; return price*(1+tax).Hint: two pairs + calculation
- Task 3. Build LET with units 8 and rate 40; return units*rate.Hint: result 320
- Task 4. Return text "City: Pune" using a named variable city.Hint: "City: "&city
- Task 5. Explain why LET(a, 1, a+a) is better than repeating a long formula twice.Hint: calculate once
- Task 6. Three names: a=2, b=3, c=4; return a*b*c.Hint: result 24
- Task 7. Use LET with a named discount 0.1 on €250.Hint: price*(1-disc)
- Task 8. Intentionally omit the final calculation and note the error, then fix it.Hint: pairs need a finale
- Task 9. Rewrite a nested IF using LET names for clarity (any simple example).Hint: name the test value first
- Task 10. Bonus: combine LET with IF to label totals ≥1000 as "Big".Hint: name total, then IF(total>=1000…)
Quick quiz
Answers: Q1=True, Q2=False, Q3=False, Q4=calculate once.