New! Post your LAMBDA functions to https://www.mrexcel.com/board/forums/excel-lambda-functions.40/

Ground-breaking news in Excel. The partner to the LET function was just released. Check out the new LAMBDA function in Excel. This makes the Excel formula language Turing Complete. Store formula logic in a name and pass parameters to that logic.
Link to the Brian Jones article: https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-turn-excel-formulas-into-custom-functions/ba-p/1925546
Table of Contents
(0:00) Introduction to Lambdas and Revenge of the Nerds
(0:26) Alonzo Church and Alan Turing
(1:52) First LAMBDA: Case Quantity
(3:10) Hypotenuse of a Triangle using HYP
(3:49) Area of a Pizza
(4:55) Using Data Types – Distance Between Two Cities
(5:52) Recursion example from Brian Jones
(6:24) Wrap-up