Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
RANDARRAY
RANDARRAY generates a dynamic array of random values with control over the grid dimensions, minimum, maximum, and whether results are integers or decimals. It is a modern dynamic-array function available in Excel 365 and Google Sheets, recalculating on every change.
Topic:SaaS metricsExcel
=RANDARRAY(4,2,1,100,TRUE)Google Sheets
=RANDARRAY(4,2,1,100,TRUE)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
- 14 is the number of rows to generate; 2 is the number of columns.
- 21 and 100 are the minimum and maximum values of the random numbers.
- 3TRUE requests whole integers; FALSE (or omitted) returns decimals.
Need a version for your data?
Try: “Generate a 4-row by 2-column grid of random integers between 1 and 100”
More on SaaS metrics
See all →Reference
ARRAYTOTEXT
Converts an array or range into a single text string, with concise or strict formatting options.
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.
ReferenceMAKEARRAY
Creates an array of specified dimensions by applying a LAMBDA function to generate each cell value.
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.