Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function ... and in cell A1 of Sheet 1, type: =LAMBDA(a,b,a*b) but don't press Enter just ...

At the bottom of the workbook, you’ll see the sheet tabs (tabs for the spreadsheets). Within any Excel workbook you create ... a function to perform an operation on cells or values. Examples ...