evaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility) · from google sheets · no excel equivalent · sheets: not yet compared

signature

ARRAYFORMULA(expression)

returns: array

argument	required
expression	required

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

related

• ARRAY_CONSTRAIN truncates a range to at most the given rows and columns
• ARRAYTOTEXT converts array to text representation
• BYCOL applies lambda to each column of array
• BYROW applies lambda to each row of array
• CHOOSECOLS returns the specified columns from an array
• CHOOSEROWS returns the specified rows from an array