Simply put, LAMBDA allows you to define your own custom functions using Excel’s formula language.
Excel formulas are the world’s most widely used programming language, yet one of the more basic principles in programming has been missing, and that is the ability to use the formula language to define your own re-usable functions. Today we are releasing to our Beta customers a new capability that will revolutionize how you build formulas in Excel.