Creates custom, reusable functions and calls them by a friendly name.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
LAMBDA([parameter1, ...], calculation)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)Résultat : 110
Defines a function that multiplies the input by 1.1 and immediately applies it to 100.
Yes, you can call a LAMBDA function immediately by adding parentheses with arguments at the end of the formula.