Which functions run a LAMBDA in Google Sheets?

MAP, REDUCE, SCAN, BYROW, BYCOL and MAKEARRAY take a LAMBDA and apply it to ranges. Named functions can also hold one under a reusable name.

Google Sheets function

LAMBDA in Google Sheets

Google Sheets supports LAMBDA together with the helper functions MAP, REDUCE, SCAN, BYROW, BYCOL and MAKEARRAY.

LAMBDA(parameter1, …, calculation)

A LAMBDA you want in many places is best saved as a named function from the Data menu.

For a fuller explanation of the arguments and common errors, see the LAMBDA Excel guide.

Formula: E2: =MAP(A2:A4,LAMBDA(p,ROUND(p*1.2,2)))

Result: Spills down: 24, 18, 9.6

The parameter p stands for each price in turn, and MAP spills one result per price.

Formula: E2: =MAP(A2:A4,LAMBDA(p,IF(p>=15,"High","Low")))

Result: Spills down: High, High, Low

The same LAMBDA can contain a decision, here labelling prices of 15 or more.

Formula: E2: =REDUCE("",C2:C4,LAMBDA(acc,w,acc&IF(acc="","",", ")&w))

The accumulator acc grows with each word w, and a comma is added from the second word on.

A tiny spreadsheet with example data. Edit the formula or any number and see the result.

Formula in F2: =MAP(C2:C4,LAMBDA(x,x*2))

Result in F2: 240

Which functions run a LAMBDA in Google Sheets?: MAP, REDUCE, SCAN, BYROW, BYCOL and MAKEARRAY take a LAMBDA and apply it to ranges. Named functions can also hold one under a reusable name.

Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.