## 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

- Click on an
**empty cell**(like F5 ).

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

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

4. Select **math and trig** category.

5. Select **LET** function

6. Then select **ok**.

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

## Examples of **LET** function in Excel

**Example 1:**

**How to use LET function in excel**

You can see examples of LET function below:

**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?

**LET**

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?

**LET**

It returns a number.

## How many arguments does **LET** function have?

**LET**

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?

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

## Errors in **LET** function

**LET**## LET** related functions :**

- LAMBDA function
- MAP Function
- SCAN Function
- REDUCE Function