Excel LET Function

What is LET Function in Excel?

The LET function is one of the math functions of Excel.

It Assigns calculation results to names.

It is useful for storing intermediate calculations and values by defining names inside a formula.

These names only apply within the scope of the LET function.

We can find this function in Math & trig category of insert function Tab.

How to use LET function in excel

  1. Click on an empty cell (like F5 ).
empty cell in excel

2. Click on fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select math and trig category.

5. Select LET function

6. Then select ok.

excel  LET function

7. In the function arguments Tab you will see LET function.

8. Name1, name2,… the name, or a calculation which can make use of all names within the LET.

The Names must start with a letter, cannot be the output of a formula, or conflict with range syntax.

9. Name_value is name values the value associated with the name.

10. You will see results in the formula result section

How to use LET function in excel

Examples of LET function in Excel

Example 1:

How to use LET function in excel

You can see examples of LET function below:

Examples of LET function in Excel
let(a,1,a+1) ----->>>>answer is  2

let(b,2,b-1) ----->>>>answer is  1

let(c,3,c*3) ----->>>>answer is  9

let(x,4,x^2) ----->>>>answer is  16

let(y,5,y/5) ----->>>>answer is  1

What is the purpose of LET function?

It Assigns calculation results to names.

It is useful for storing intermediate calculations and values by defining names inside a formula.

What is the Return value of LET function?

It returns a number.

How many arguments does LET function have?

This function has just 5 Argument.

The argument of LET function is number.

Name1, name2,… the name, or a calculation which can make use of all names within the LET.

The Names must start with a letter, cannot be the output of a formula, or conflict with range syntax.

Name_value is name values the value associated with the name.

The argument of LET function is required and not optional.

LET(number) = number

Which version of excel supports LET function?

This function is available for all excel versions (2003-2019)

Errors in LET function

LET related functions :

  • LAMBDA function
  • MAP Function
  • SCAN Function
  • REDUCE Function

Leave a Reply

Your email address will not be published. Required fields are marked *