MAKEARRAY
Returns a calculated array of a specified row and column size, by applying a LAMBDA
Syntax
MAKEARRAY(rows, cols, lambda)
Parameters
- 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 each value in the array, taking two parameters (row index, column index)
Example
=MAKEARRAY(3, 3, LAMBDA(r, c, r * c))