Functions
LAMBDA
Create a lambda function
Try it
When to use it
When should I use LAMBDA?
Use LAMBDA to define a reusable custom function inline — wrap a calculation in LAMBDA so you can call it multiple times within the same workbook without repeating the formula.
Syntax
LAMBDA(param1, ..., body)