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

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

    Syntax

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

    Argument

    This function has the following arguments:

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

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

    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.

    Remarks

    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.

    Examples

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

    MAKEARRAY(D2,E2,LAMBDA(row,col,CHOOSE(RANDBETWEEN(1,3),"Red","Blue","Green")))

    Version Available

    This function is available in product version 15 or later.