Logical
Modern
LAMBDA
Turns a formula into a reusable custom function with named parameters, callable like a built-in function.
Available in Microsoft 365 · Excel 2024 · Excel for the web. NOT Excel 2021 (MS page: 365 + 2024 only). Not 2019/2016.
Syntax
LAMBDA(parameter_or_calculation, ...)What it returns
A function value — or its result when called with arguments.
Arguments
| Argument | Required | Description |
|---|---|---|
parameter_or_calculation |
Yes | One or more parameter names, then the final calculation (last item). |
… |
No |
Example
=LAMBDA(x, x*2)(5)Important to know
The last item is always the calculation; everything before it is a parameter name.
Usually saved via Name Manager to create a named, reusable function.
Call it by following the LAMBDA with arguments in parentheses.
Related functions
Related learning
No MEE lesson covers this function yet.