Assigns names to calculation results to allow for intermediate variables in a formula.
Syntax
LET(name1, value1, [name2, value2, ...], calculation)Argument
name1obligatoriskt
The name to assign to the first value.
value1obligatoriskt
The value or calculation to assign to name1.
calculationobligatoriskt
The final result to return, which can use the defined names.
The LET function improves formula readability and performance by storing intermediate values as named variables. This eliminates the need to repeat complex calculations multiple times within the same formula.
=LET(x, 5, x*x)→25Assigns the value 5 to x, then calculates x squared.
Define variables
Enter pairs of names and their corresponding values or expressions.
Perform calculation
Write the final formula using the names defined in the previous steps.
Yes, LET can be nested within other Excel functions to simplify complex logic.