PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

EXCEL FUNCTIONS-LET

INTRODUCTION

Hi!

Remember the junior classes of Mathematics when we used to let the value of X.

Something same has been introduced by Microsoft Excel to its users. The name of this new function is

LET.

But , remember, this function is just a BETA FEATURE for now and not available in any of the versions but only a portion of the insiders.( A group to test the beta features which are not yet fully released.)

So it is quite possible that you won’t find this function in your Excel for now.

Later on, it’ll be most probably introduced to OFFICE 365.

But even then, it is never a bad idea to gain a little bit of extra knowledge.

So let us see, how the LET FUNCTION will work with a few simple examples.

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.

Helpful links for the prerequisites mentioned above

What Excel does? How to use formula in Excel?

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

Let us try it with the simplest formula SUM.

We’ll declare two variables x and y and pass the values to them and try to find out the sum from this function.

So the format goes like this

=LET(x,7,y,6,sum(x,y))

The output returned 13.

EXAMPLE 2:AGGREGATE FUNCTION IN EXCEL USING K ARGUMENT

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(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.

CONTENTS

EXCEL FUNCTIONS-LET

INTRODUCTION

PURPOSE OF LET FUNCTION IN EXCEL

PREREQUISITES TO LEARN LET FUNCTION

SYNTAX: LET FUNCTION

EXAMPLE 1:LET FUNCTION IN EXCEL

EXAMPLE 2:AGGREGATE FUNCTION IN EXCEL USING K ARGUMENT

DATA SAMPLE

WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

Like this:

Pin It on Pinterest

KINDLY SPEND FEW SECONDS HERE....