LET Function: syntax, examples, mistakes and translation notes
Assigns names to calculation results inside a formula.
Syntax
=LET(name1, name_value1, [name2, name_value2, ...], calculation)
Arguments
name1
Name for the first intermediate value.
name_value1
Value/expression assigned to that name.
calculation
Final expression that can use the defined names.
Worked examples
=LET(rate,B2,total,C2,rate*total)
Names two inputs and multiplies them in the final expression.
=LET(clean,TRIM(A2),IF(clean="","Missing",clean))
Reuses a cleaned text value without recalculating TRIM.
Practical tips
- Use descriptive names that explain the business idea.
- During debugging, temporarily return one intermediate name as the final calculation.
- LET can improve readability even when performance is unchanged.
Common mistakes
- Using names that look like cell references or conflict with workbook naming rules.
- Creating many tiny names that make a simple formula harder rather than easier.
Related functions
Frequently asked questions
What does LET do?
Assigns names to calculation results inside a formula.
Why might a LET formula return an unexpected result?
Using names that look like cell references or conflict with workbook naming rules. Start by testing the smallest referenced range or condition independently before adding wrappers or fallbacks.
Check the complete formula
Function syntax is only one part of a working workbook. Paste the finished expression into the Formula Checker for structural warnings, the Formatter for readability or the Translator when a supported locale mapping is involved.
Testing note: examples are educational. Spreadsheet versions, locale settings, tables, named ranges and workbook data can change behavior, so validate important formulas with representative data.