PURPOSE OF LET FUNCTION IN EXCEL
LET FUNCTION assigns a name to values and those names can be used in the calculation argument of the LET FUNCTION.
PREREQUISITES TO LEARN LET FUNCTION
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Of course, Excel software.
SYNTAX: LET FUNCTION
The syntax of the LET FUNCTION is as follow:
LET( variable name, variable value , variable2 name, variable2 value,…., calculation)
variable name is the name of our variable say x, y, or a,b,c or any other string like area, volume etc.
variable value is the value of the variable which we specified by the name. It’ll go in pair as shown in the syntax.
calculation is the calculation involving the variables, It can use functions or can be as long as you want but of course within the limits.
EXAMPLE 1:LET FUNCTION IN EXCEL
EXAMPLE 2:AGGREGATE FUNCTION IN EXCEL USING K ARGUMENT
This option of using LET FUNCTION lends us a good help in the functions which becomes very lengthy and needs to be again and again referred to.
We can provide the useful range as the variable just once and use the variable frequently in the formula. We doesn’t need to look the cell again and again to find out what it meant.
Suppose we need to find out if the day is equal to the day put in A13 cell. The day can change.
Now let us try it with LET FUNCTION
=If(A13=”SUNDAY”,”The day is correct”,”The day is incorrect”)
=LET(X,A13,Y,SUNDAY,IF(X=Y,”The day is correct”,”The day is incorrect”)
The second function is more readable and understandable.
And the LET functions are twice faster to the standard functions as once the value is given to the variable it is not again and again referenced to the different locations.
OTHER WAYS TO REACH THIS ARTICLE
WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL
YOU MAY LIKE
- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.