A function that enables one formula to return values into multiple cells by treating ranges as arrays. It "expands" a formula across rows/columns.
=ARRAYFORMULA(A2:A5 * 2) will double each value in A2:A5 and output all results in the same column.
