
PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
CONTENTS
EXCEL FUNCTIONS-LET
INTRODUCTION
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.
For example,
Suppose we need to evaluate an equation as A13^2+B12^2 …
If you have used lengthy calculations in EXCEL you’ll realize how difficult it becomes to catch the errors and using the different addresses makes our formulas prone to mistakes.
LET FUNCTION takes care of that part.
We can rephrase this function as
=LET(X,A13,Y,B12,SUM(X^2,Y^2))
It is clear that the statement involving the LET function is more readable and less prone to error as we need to use the addresses only once.
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
STEPS TO USE LET FUNCTION IN EXCEL:
EXPLANATION
EXAMPLE 2: HANDLE LENGTHY CALCULATIONS EFFECTIVELY USING LET FUNCTION
DATA SAMPLE
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(C13=”SUNDAY”,”The day is correct”,”The day is incorrect”)
=LET(X,C13,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.