Create your own functions from formulae in Microsoft Excel using LAMBDA
Microsoft has launched a new feature for Excel which it says will revolutionize formulae. Called LAMBDA, the new capability is being made available to Beta users for now, and it introduces the ability to create custom functions using Excel's formula language.
The company points out that Excel formulae are the world's most widely used programming language, and now it has gained the option of defining custom, reusable functions. There's no need to learn a complex programming language, making LAMBDA accessible to all.
See also:
- Developers manage to run Windows 10 and Linux on M1 Macs
- Microsoft releases the much-improved PowerToys v0.27.0
- Here's how to get a longer timeframe to remove Windows 10 feature updates
Writing on the Excel blog, Microsoft's Brian Jones explains: "Simply put, LAMBDA allows you to define your own custom functions using Excel’s formula language. Excel already allows you to define custom functions, but only by writing them in an entirely different language such as JavaScript. In contrast, LAMBDA allows you to define a custom function in Excel’s own formula language".
He goes on to say:
Moreover, one function can call another, so there is no limit to the power you can deploy with a single function call. For folks with a computer science background, you’re probably already familiar with the concept of lambdas, and the introduction of LAMBDA makes the Excel formula language Turing Complete...
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.
More details and examples can be found on the Excel blog.
Microsoft has not said when this will start to roll out to all Excel users, so if you want to try out the capabilities of LAMBDA for yourself, you can sign up for the Office Insider Program and choose the Beta Channel.