LAMBDA

Creates custom reusable functions in Excel without VBA. Define the function once with named parameters, then call it anywhere like a built-in function. LAMBDA functions can be recursive.

Syntax

excel-mastery

=LAMBDA([param1, param2, ...], calculation)

Example

excel-mastery

Named in Name Manager as "Discount":
=LAMBDA(price, rate, price * (1 - rate))

Usage:
=Discount(A2, 0.15)

Recursive factorial:
=LAMBDA(n, IF(n<=1, 1, n * factorial(n-1)))