# LET

Formulas / LET
Assign variables in a formula.
`=LET(name1, name_value1, calculation_or_name2, [name_value2, calculation_or_name3...])`
• name1 - required argument that is the first name to assign
• name_value1 - required argument that is the value assigned to name1
• calculation_or_name2 - required argument that is a calculation that uses all the names in the LET function
• name_value2 - [OPTIONAL] argument that is the value assigned to calculation_or_name2
• calculation_or_name3 - [OPTIONAL] argument that is a calculation that uses all the names in the LET function
• name_value3 - [OPTIONAL] argument that is the value assigned to name_value2
• calculation_or_name4 - required argument

## Examples

• `=LET(x,10,x+1)`

The LET function can be used to assign a value to a variable, and use the variable in a calculation. In the example, the LET function assigns the value 10 to the variable "x", and then adds 1 to the value of "x". This expression returns the value 11.

• `=LET(x,10,y,5,x+y)`

The LET function can also be used for more complex calculations that involve multiple variables. For example, this formula assigns the value 10 to the variable "x" and the value 5 to the variable "y", and then adds the two values together. This expression returns the value 15.

## Summary

The LET function is a useful tool for defining and creating named variables in a formula. It helps to simplify and organize data in a formula.

• The LET function reduces redundant calculations to improve performance and makes complex formulas easier to read and write.
• The LET function is often used with LAMBDA to make a complex formula easier to understand.