Moreover, one function can call another (including itself), so there is no limit to the power you can deploy with a single function call. In Office 365 Beta, LAMBDA allows you to define a custom function in Excel’s very own formula language. It’s user-defined functions without a Ph.D. Simply put, LAMBDA allows you to define your own custom functions using Excel’s formula language. If this means nothing to you and you are now possessing a glazed expression, don’t worry, welcome to my world. He coined the term as part of lambda calculus, in which all functions were deemed “anonymous”, ie, one that is not bound to an identifier. The name dates back to Alonzo Church, a mathematician and logician who made major contributions to mathematical logic and the foundations of theoretical computer science.
Confusingly, LAMBDA has nothing whatsoever to do with previous Greek-named functions such as BETA and GAMMA.