Spread.NET 16 Formula Reference
Formula Functions / Functions M to Q / MAKEARRAY
In This Topic
    In This Topic

    This function returns a calculated array of a specified row and column size, by applying a LAMBDA.


    MAKEARRAY(rows, cols, lambda(row, col))


    This function has the following arguments:

    Argument Description
    rows The number of rows in the array. Must be greater than zero.

    The number of columns in the array. Must be greater than zero.


    A LAMBDA that is called to create the array. The LAMBDA takes two parameters:

    row: The row index of the array.

    col: The column index of the array.


    If an invalid LAMBDA function or an incorrect number of parameters are provided, it returns a #VALUE! error called "Incorrect Parameters". If a row or col argument is set to a value < 1 or to a non-number, it returns a #VALUE! error.

    Data Types

    Returns an array.


    MAKEARRAY(3, 3, LAMBDA(r,c, r*c))


    Version Available

    This function is available in product version 15 or later.