Syntax
=LAMBDA(parameter1, [calculation], ...)Arguments
| Argument | Required | Description |
|---|---|---|
parameter1 | Required | A parameter name |
calculation | Optional | The calculation (last argument) |
How to use LAMBDA
LAMBDA takes 1 required argument and 1 optional argument, and accepts more values in the same pattern. Type =LAMBDA( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=LAMBDA(x, x*2)(4)Result =LAMBDA(a, b, a+b)(2, 3)Result Related logical functions
- IFReturns one value when a condition is TRUE and another when it is FALSE.
- IFERRORReturns a value of your choice when a formula gives an error, otherwise the formula result.
- IFNAReturns a value of your choice when a formula gives #N/A, otherwise the formula result.
- IFSChecks conditions in order and returns the value of the first one that is TRUE.
- LETNames the results of calculations so a formula can reuse them.
- NOTReverses a logical value.
- ORTRUE when any argument is TRUE.
- SWITCHCompares a value with a list of cases and returns the result of the first match, or a default.
- TRUEThe logical value TRUE.