deepcalc
DocsARRAYFORMULA

ARRAYFORMULA

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

Evaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility).

  • Excel: No equivalent
  • Google Sheets: Not checked yet
  • Returns: Array

Examples

=ARRAYFORMULA(A1:A3*2)
A
1 10
2 20
3 30
Result 20

Syntax

ARRAYFORMULA(expression)
expression
range required
ARRAY_CONSTRAINTruncates a range to at most the given rows and columns. 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. CHOOSEROWSReturns the specified rows from an array.