MAKEARRAY

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

Syntax

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

Argument	Description
rows	[Required] The number of rows in the array. Must be greater than zero.
cols	[Required] The number of columns in the array. Must be greater than zero.
lambda	[Required] 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.

Argument

Description

rows

[Required] The number of rows in the array. Must be greater than zero.

cols

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

lambda

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

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