What does "Function XYZ is an array function" mean?

An array function is a function that returns multiple values (i.e. an array of values). For instance, the DIFF function returns the whole time series of the differenced time series.

An array function returns the value of the first element by default. To expand the values, please select all cells column-wise (starting from the cell with formula), hit F2 to view the formula and hit CTRL+SHIFT+ENTER together. If successful, you will see the formula enclosed between italic braces (i.e. {}).

Have more questions? Submit a request