The LAMBDA function is a new entry in the vast empire of Excel.
The function is yet to be introduced officially and available only for the beta users of OFFICE 365 only.
LAMBDA FUNCTION LETS THE USER DEFINE HIS OWN FUNCTION WHICH CAN BE REUSED AGAIN AND AGAIN JUST LIKE WE CREATE ONE IN VBA BUT SIMPLER THAN THAT.
LAMBDA function gives us an extreme power to declare our own function for local calculation.
For Example, if we need to use any function over and again, we can declare it using LAMBDA and use it at our convenience.
In this article, we would learn to use LAMBDA FUNCTION , its purpose, syntax formula and a few examples.
LAMBDA FUNCTION lets us create a custom function in Excel very easily.
It is a great function as we can create a function on our own, as per requirement and use it over and again.
We can declare the variables too.
For example, suppose we need to evaluate an equation with two variable such as (a+b)². This formula contains a and b as variables.
So we can create a function using LAMBDA such as DOUBLEVARIABLESQUARE.
We’ll discuss it further in the examples discussion.
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
The Syntax for the LAMBDA function is
=LAMBDA( [VARIABLE 1, VARIABLE 2 , VARIABLE 3…VARIABLE 253] EXPRESSION )
We took this example for a specific purpose.
1. This function is not directly available in Excel.
2. This is a very basic function and easy to understand.
The first step is to create and check the function usage.
FOLLOW THE STEPS TO CREATE A LAMBDA IN A CELL FOR VERIFICATION
LAMBDA IN A CELL means to create the function in a single cell and trying it using the dummy values before putting it into real work.
This is the first step , which verifies our function to be correct.
After we are satisfied with the working of the function, it is time to name it so that we can use it at our will.
So let us name it now.
FOLLOW THE STEPS TO NAME THE CUSTOM FUNCTION MADE USING LAMBDA
So , we just created a new function known as FIFTH_POWER and we are ready to use this.
FOLLOW THE STEPS TO USE THE CUSTOM FUNCTION MADE USING LAMBDA
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE