Assigns names to calculation results to allow for intermediate variables in a formula.
Sintaxis
LET(name1, value1, [name2, value2, ...], calculation)Argumentos
name1obligatorio
The name to assign to the first value.
value1obligatorio
The value or calculation to assign to name1.
calculationobligatorio
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.