Logical
Modern
LET
Names intermediate calculations inside a formula so a value is computed once and reused — clearer, faster formulas.
Available in Microsoft 365 · Excel 2024 · Excel 2021 · Excel for the web. Not 2019/2016.
Syntax
LET(name1, name_value1, calculation_or_name2, ...)What it returns
The result of the final calculation.
Arguments
| Argument | Required | Description |
|---|---|---|
name1 |
Yes | |
name_value1 |
Yes | |
calculation_or_name2 |
Yes | |
… |
No |
Example
=LET(r, 0.2, A2*(1+r))Important to know
The last argument must be the calculation that returns the result.
Names can't clash with cell references or defined names.
Avoids recomputing a repeated sub-expression.
Related functions
Related learning
No MEE lesson covers this function yet.