# Learn How to Use Microsoft Excel LET Function

Written by | 0 Comments | 649 Views

In this article, you will learn how to use the Microsoft Excel LET function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel LET function return value and syntax with the help of some examples.

Microsoft Excel LET Function

The main function of Microsoft Excel LET function is to assign variables inside the formula. That means with the help of the LET function, it will be simple for you to write various complex formulas by assigning the values to the variables inside the formula.

Return Value of LET Function

The return value will be the usual formula result.

Syntax of LET Function

=LET(name1, value1, [name2/value2], ..., result)

Where the arguments:

name1: This is the first name to assign and should begin with the letter

value1: This is the value or calculation you want to assign to the name1.

name2/value2: This is the second name and value pair and entered as an argument (optional).

result: This is a calculation or variable which was calculated previously.

## How to Use Microsoft Excel LET Function? Now we know that the LET function allows us to write complex formulas in Microsoft Excel in a simpler manner. The LET function enables the formula to declare and assign the value to the variables. When you named the value, you can able to assign it as a static value or the value as per the calculations. You can then refer the formula to a variable by a name as many times as required; however, the value of the variable is defined at one place only.

Key Benefits of LET Function

Clarity: When you name the variables inside the formula, it makes you read and use the complex formula easier.

Simplicity: When you name and define the variables in one place, it eliminates redundancy, moreover the errors that occur have the same code in more than one place.

Performance: When you eliminate the redundant code that implies, it reduces the overall calculation time. As the complex calculations are needed to occur only once.