deepcalc
DocsMAP

MAP

View as markdown/docs/functions/map.md Ask Claude about this pageOpens Claude with this page's address

Maps lambda over array values.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Array

Examples

=MAP(A1:A3, LAMBDA(v, v * 2))
A
1 10
2 20
3 30
Result 20

Syntax

MAP(array, lambda)
array
range required
lambda
any required

Errors

#VALUE!
=MAP(A1:A2, B1:B1, LAMBDA(a, b, a + b))
#ERROR!
=MAP(A2:A3)
ARRAY_CONSTRAINTruncates a range to at most the given rows and columns. ARRAYFORMULAEvaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility). ARRAYTOTEXTConverts array to text representation. BYCOLApplies lambda to each column of array. BYROWApplies lambda to each row of array. CHOOSECOLSReturns the specified columns from an array.