An array formula is a formula that can perform multiple calculations on one or more of the items in an array.
We can think of an array as a row of values, a column of values, or a combination of rows and columns of values.
Array formulas can return either multiple results or a single result.
The active cell displays the results of its formula while we see the formula itself in the Formula Bar.
Get instant updates and alerts directly from our site.
Install this app on your device for quick access right from your home screen.
