MAKEARRAY function
Returns a calculated array of a specified row and column size, by applying a LAMBDA
Syntax
MAKEARRAY(rows, cols, lambda)Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| rows | Yes | The number of rows in the array. Must be greater than zero.8 |
| cols | Yes | The number of columns in the array. Must be greater than zero.7 |
| lambda | Yes | 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).LAMBDA(r,c, r*c) |
Try MAKEARRAY
Build a grid from one-based row and column positions
=MAKEARRAY(A2,B2,LAMBDA(row,column,row*10+column))MAKEARRAY supplies row and column positions starting at 1. The body row*10+column produces 11,12 on the first row, then 21,22 and 31,32. All six outputs are checked.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
MAKEARRAY · top-level call
=MAKEARRAY(A2,B2,LAMBDA(row,column,row*10+column))Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.