Creates custom, reusable functions and calls them by a friendly name.
Sintaxe
LAMBDA([parameter1, ...], calculation)Argumentos
parameter1opcional
A value, cell reference, or string to be passed to the function.
calculationobrigatório
The formula to execute using the defined parameters.
The LAMBDA function allows you to define a custom function that can be reused throughout your workbook. It takes one or more parameters and a calculation that uses those parameters to return a result.
=LAMBDA(x, x*1.1)(100)→110Defines a function that multiplies the input by 1.1 and immediately applies it to 100.
Define the parameters
List the variables you want to use within your function logic.
Write the calculation
Provide the formula that uses the parameters to produce the desired output.
Name the function
Use the Name Manager to assign a name to your LAMBDA for easy reuse.
Yes, you can call a LAMBDA function immediately by adding parentheses with arguments at the end of the formula.