# MAKEARRAY

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns a calculated array of a specified row and column size, by applying a [LAMBDA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionLambda).

## 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.