Functions
ARRAYFORMULA
Evaluates a formula as an array formula
Try it
When to use it
When should I use ARRAYFORMULA?
Use ARRAYFORMULA to evaluate a formula as an array formula, expanding operations across multiple values without manually entering it as an array formula.
Used in
Syntax
ARRAYFORMULA(array_formula)Examples
=ARRAYFORMULA({1,2,3}*2) // => 2
=ARRAYFORMULA({1,2,3}+{10,20,30}) // => 11
=ARRAYFORMULA(SUM({1,2,3,4,5})) // => 15