Excel Functions

# Excel LET Function

Excel LET function helps in assigning names to the variables that are repeatedly used in a formula.

## Purpose

Assign a name to the calculation results in a formula. Useful for storing intermediate calculation and values by defining a name inside the formula. This makes formula easy to read and understand.

## Return value

Returns the normal formula result

## Syntax

=LET (name1, name_value1, calculation_or_name2,[name_value2…)

## Usage notes:

• LET function can assign names to variables but these names can be used only within the scope of the function.
• If you have to use the same expression or calculation multiple times in a formula, the LET Function assigns a name and allows you to call it by that name and use it multiple times in the formula. This makes it easier to read the formula and make it run faster.
• LET uses about 126 name and name-value pairs
• You cannot assign the same name twice in the function for different variables.
• LET Function is not case-sensitive.

Microsoft 365

## Example

Let’s say you have to use the tax rate “10%” multiple time in a formula, so instead of repeatedly typing it, you can assign a name to it. So we assume we assign the name “TaxRate” to it. So the formula works this way:

Formula used:  =LET(Tax,\$C\$5,D8*(1+Tax))

Tax: Name assigned to the value
\$C\$5: Name value i.e. 10%
D8*(1+Tax): Calculation. D8 is the revenue to be multiplied by the Tax Rate.

So here we aim at getting the Revenue amount including the tax rate, which returns the answer as shown in the below image:

#### Related Posts

More off this less hello salamander lied porpoise much over tightly circa horse taped so innocuously outside crud mightily…

More off this less hello salamander lied porpoise much over tightly circa horse taped so innocuously outside crud mightily…

More off this less hello salamander lied porpoise much over tightly circa horse taped so innocuously outside crud mightily…