Menu
EXCEL LET FUNCTION
Excel LET Function Introduction
In a formula, give the computation results a name. By designating a name inside the formula, it is possible to save intermediate calculations and values.
Description of Excel LET Function
Syntax :
Parameters :
- The following parameter are:
name1 –
- The first name given to a value or cell reference.
name value1 –
- The value to which a name is allocated 1.
calculation-
- A computation that makes use of names within the LET Function.
Step By Step Guide of LET Function
Example :
Assume you need to utilise the tax rate “10%” in a calculation several times, and instead of entering it each time, you may give it a name. So we’ll call it “TaxRate” for the time being. So here’s how the formula works:
Formula used: =LET(Tax,$C$5,D8*(1+Tax))
Key Points
- The LET function can rename variables, but these names are only used inside the range of the function.
- If you need to utilise the same expression or calculation in a formula many times, the LET Function provides a name to it and lets you to refer to it by that name and use it numerous times in the formula.
- This makes the formula easy to read and helps it run faster.
- LET employs around 126 name and name-value pairings.
- In the function, you cannot use the same name for separate variables twice.
- The LET Function does not care about case.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
