Microsoft introduced a new capability that will revolutionize how you build formulas in Excel. The new feature called LAMBDA is currently available to M365 Beta customers.
LAMBDA allow you to define a custom function in Excel’s own formula language. Moreover, one function can call another, so there is no limit to the power you can deploy with a single function call.
Read the complete article here.