Microsoft today announced a new feature that will revolutionize how you build formulas in Excel. Excel formulas are extremely popular, but you can’t use the formula language to define your own re-usable functions. The new LAMBDA feature will allow you to define your own custom functions using Excel’s formula language. You can also call one function from another.
Reusable Custom Functions
With LAMBDA, you can take any formula you’ve built in Excel and wrap it up in a LAMBDA function and give it a name (like “MYFUNCTION”). Then anywhere in your sheet, you can refer to MYFUNCTION, re-using that custom function throughout your sheet. I’ll show a couple examples below.
=LAMBDA([parameter1, parameter2, …,] calculation)
|parameter||A value that you want to pass to the function, such as a cell reference, string or number. You can enter up to 253 parameters. This argument is optional.|
|calculation||The formula you want to execute and return as the result of the function. It must be the last argument and it must return a result. This argument is required.|
The new lambda function is available to Office Insiders on Microsoft Windows and Mac builds of Excel.