The RANDARRAY function generates an array of random numbers between 0 and 1. The size of the array is determined by the provided rows and columns arguments.

Parts of a RANDARRAY function

RANDARRAY(rows, columns)

PartDescription
rowsThe number of rows to return [optional]. Must be specified if columns is specified.
columnsThe number of columns to return [optional].

Sample formulas

Example 1 RANDARRAY()

Example 2 RANDARRAY(4, 2)

Notes

  • If rows and columns are omitted, RANDARRAY returns a 1 x 1 sized grid.
  • Like the RAND function, hitting enter will cause RANDARRAY’s results to update.

Examples

1FormulaResult
2=RANDARRAY()0.292929292
3
4
1FormulaResult
2=RANDARRAY(4,2)0.35464566
30.45674863412
40.4565146
50.7878945
  • RAND Returns a random number between 0 inclusive and 1 exclusive.