LAMBDA
Create custom, reusable functions and call them by a friendly name
Syntax
LAMBDA([parameter1, parameter2, ...], calculation)
Parameters
- parameter1: Optional. A value that you want to pass to the function, such as a cell reference, string, or number
- calculation: Required. The formula expression to execute and return as the result of the function. Must be the last argument
Example
=LAMBDA(x, y, x + y)(2, 3)