Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
MAKEARRAY
MAKEARRAY builds a two-dimensional array with a given number of rows and columns, calling a LAMBDA with the current row and column index for each cell. Use it to generate multiplication tables, sequential grids, or any computed matrix without entering values manually.
Topic:SaaS metricsExcel
=MAKEARRAY(3, 3, LAMBDA(r, c, r*c))Google Sheets
=MAKEARRAY(3, 3, LAMBDA(r, c, r*c))Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Specify the number of rows and columns the output array should have.
- 2Write a LAMBDA with two parameters (row index and column index) that returns the desired value for each position.
- 3The formula spills a rows-by-columns array starting from the cell where you enter it.
Need a version for your data?
Try: “Generate a 5x5 multiplication table automatically with a formula”
More on SaaS metrics
See all →Reference
RANDARRAY
Spills a grid of random numbers with specified rows, columns, min, max, and integer/decimal options. Excel 365 and Google Sheets only.
How-toHow to calculate churn rate
Calculate monthly or annual customer churn rate as lost customers divided by starting customers, expressed as a percentage, in Excel and Google Sheets.
Error fixFix #####
Fix ##### in Excel — the column is too narrow to display the number or date. Widen the column or change the format to resolve it.
ReferenceARRAYTOTEXT
Converts an array or range into a single text string, with concise or strict formatting options.
How-toHow to calculate monthly recurring revenue (MRR)
Learn how to calculate MRR in Excel and Google Sheets using SUMIF to sum active subscription revenue by billing period, normalized to a monthly figure.
Error fixFix Array result
Array result was not expanded in Google Sheets means output cells are blocked. Clear adjacent cells or use a blank area.