LAMBDA in Google Sheets, Name a Formula
By Szabó Gergő · Updated
LAMBDA lists parameter names, then the formula that uses them. A bare LAMBDA is a function until you call it.
Syntax and arguments
=LAMBDA(param1, param2, ..., calculation)- param
- Placeholder name used inside the calculation.
- calculation
- Formula that references those names.
LAMBDA examples
01
Inline with BYROW
Row totals.
=BYROW(B2:C10, LAMBDA(r, SUM(r)))Defines the row function next to BYROW.
02
Call a LAMBDA once
Quick test.
=LAMBDA(a,b, a+b)(3,4)The trailing parentheses pass 3 and 4. Result is 7.
03
Named function
Saved as TAX.
=TAX(A2,0.27)After you save LAMBDA(amount,rate, amount*rate) as TAX.
Common mistakes
Leaving a bare LAMBDA in a cell
Call it with trailing parentheses or pass it to BYROW.
Using it for a one-off cell
Name a LAMBDA when three sheets copy the same nest.
Excel named-function menus
Sheets named functions live under Data. The idea matches Excel.
LAMBDA FAQ
Why does LAMBDA show as a formula, not a value?
A bare LAMBDA is a function. Call it with trailing parentheses or pass it to BYROW.
Is this the same as Excel LAMBDA?
The idea matches. Named functions live in different menus on each platform.
When should I skip LAMBDA?
One-off cells do not need it. Name a LAMBDA when the same nest is copied often.