LAMBDA function in Excel

Syntax

=LAMBDA(parameter1, …, calculation)

Example

Define Margin as =LAMBDA(price, cost, (price-cost)/price) and use =Margin(B2, C2). Fix the logic once in Define Name and every cell that uses it updates.

From the lesson LAMBDA Function.

Common mistakes

• Typing =LAMBDA(x, x*2) alone in a cell: it defines a function but never calls it (Excel shows #CALC!). Add the input: =LAMBDA(x, x*2)(A2).
• Giving a parameter a name that looks like a cell address (A1, TAX1).
• Passing a different number of inputs than the LAMBDA has parameters (#VALUE!).

Related dynamic array functions

• UNIQUEReturns the unique values in a range (spills).
• FILTERReturns rows that meet a condition (spills).
• SORTSorts a range (spills).
• SEQUENCEGenerates a list of numbers (spills).
• LETNames intermediate results inside one formula.