# MAKEARRAY

## Content

This function returns a calculated array of a specified row and column size, by applying a [LAMBDA function](/document-solutions/dot-net-excel-api/docs/online/Features/ManageFormulas/lambda-functions).

## Syntax

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

## Arguments

| 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: <ul><li>row - The row index of the array.</li><li>col - The column index of the array.</li></ul> |

## Examples

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