This is a 1 hour 45 min. video about everything that the Excel LAMBDA function can do.
This video is also a complete lesson in Defined Names, the LET function and Spilled Single Cell Formula Reports.Course taught by Excel MVP and Highline College Professor, Mike Girvin. Course is Microsoft 365 Excel Complete Story.
For example, to create a LAMBDA function that calculates the square of a number, you could use the following syntax:
You can then use this function in other cells by referencing the cell that contains the LAMBDA function and providing the input value as an argument. For example, to calculate the square of the number 5, you could use the following formula: