[]
DEMOS BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

MAKEARRAY

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.