Reference
No results for 'undefined'
    Powered by Algolia

    ARRAYFORMULA

    Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.

    Syntax

    =ARRAYFORMULA(array_formula, [num_rows], [num_cols], [extract_values])

    Parameters

    1. array_formula
      • Type: Any
      • Description: A range, mathematical expression using one cell range or multiple ranges of the same size, or a function that returns a result greater than one cell.
    2. num_rows [optional]
      • Type: Integer
      • Description: The number of rows the result should contain.
    3. num_cols [optional]
      • Type: Integer
      • Description: The number of columns the result should contain.
    4. extract_values [optional]
      • Type: Boolean
      • Description: Extract values from frame. Default values is TRUE.

    Features

    • ArrayFormula.

    Returns

    • Type: Any
    • Description: Returns first item of array

    Example

    =ARRAYFORMULA(A1:C1+A2:C2)
    Contents