LAMBDA function

LAMBDA is a new Excel function that allows easy creation of formulas, for one or more parameters. It works similarly to the LET function, but offers significantly greater capabilities. This feature was announced 2 years ago and only today it was included in the Microsoft365 update, so I’m looking forward to finally sharing with you the knowledge of how to use it. Let’s get to know the LAMBDA function!

The syntax of this function is:

LAMBDA (<p1>, …, <pn>, <formula>) [(<address p1>, …, <address pn>)]

The first arguments of this function are one or more parameters, followed by the formula within which these parameters are used. Then, in parentheses, you need to specify the cell addresses where the parameters are located.

For example, if we want to calculate the circumference of a circle based on the values ​​of the radius in a given table, we will write the formula:

=LAMBDA(R,2*PI()*R)(A4)

and copy it into the remaining cells.

We can also use the LAMBDA function to define a budget by creating a name. To do this, we will start the Name Manager and add a new name, and enter the formula as the value. Later, we simply enter the name, as we would specify the name of the function, and then specify the parameters in parentheses.