LET
TheLET
formula allows you to create variables in a formula and define their value before using them. This can make complex formulas easier to read and maintain by breaking them into smaller parts. It is most commonly used in combination with other formulas to simplify complex formulas.
 How to use
LET
formula?  Examples of using
LET
formula LET
formula not working? Similar formulas to
LET
Usage
Use the LET
formula with the syntax shown below, it has 3 required parameters and 2 optional parameters:
 name1 (required):
The name of the first variable to create.  value_expression1 (required):
The expression that defines the value of the first variable.  name2 (optional):
The name of any additional variables to create.  value_expression2 (optional):
The expression that defines the value of any additional variables.  formula_expression (required):
The formula expression that uses the previously defined variables.
Examples
Here are a few example use cases that explain how to use theLET
formula in Google Sheets.
Simplifying complex formulas
By breaking a complex formula into smaller parts using LET
, you can make it easier to read and maintain.
Reducing formula errors
Using LET
to define variables can reduce the likelihood of formula errors by making it easier to keep track of each part of a complex formula.
Nesting formulas
You can use LET
to nest formulas inside each other, creating a hierarchy of variables and formulas that can be easier to understand and debug.
Common Mistakes
LET
not working? Here are some common mistakes people make when using the LET
Google Sheets Formula:
Not using the correct syntax
Make sure you follow the correct syntax for LET
when defining variables and using them in your formula.
Forgetting to close parentheses or quotes
Make sure you close all parentheses and quotes in your formula, as leaving them open can cause errors.
Using the wrong variable name
Doublecheck that you are using the correct variable name in your formula expression.
Related Formulas
The following functions are similar to LET
or are often used with it in a formula:

IF
The
IF
formula is a logical function used to test a condition and return one value if the condition is true and another value if the condition is false. It is commonly used to create conditional statements and perform calculations based on certain conditions. 
AND
The
AND
function in Google Sheets is a logical function that returns TRUE if all of the logical expressions in the argument are TRUE, and FALSE if any of the logical expressions are FALSE. It can be used to test multiple conditions and evaluate whether they are all true or not. 
OR
The
OR
formula is a logical formula that returns TRUE if at least one of the provided logical expressions is TRUE. It returns FALSE if all logical expressions are FALSE. This formula is commonly used in conjunction with other logical formulas, such asAND
, to build more complex logical statements. 
SUM
The
SUM
function in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells. 
AVERAGE
The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.
Learn More
You can learn more about the LET
Google Sheets function on Google Support.