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)
| Part | Description |
|---|---|
rows
|
The number of rows to return [optional]. Must be specified if columns is specified. |
columns
|
The 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
| A | B | |
|---|---|---|
|
1
|
Formula | Result |
|
2
|
=RANDARRAY() | 0.292929292 |
|
3
|
||
|
4
|
| A | B | C | |
|---|---|---|---|
|
1
|
Formula | Result | |
|
2
|
=RANDARRAY(4,2) | 0.35464566 | 0.124214214 |
|
3
|
0.45674863412 | 0.4561312 | |
|
4
|
0.4565146 | 0.12645601 | |
|
5
|
0.7878945 | 0.13459698 |
Related functions
- RAND Returns a random number between 0 inclusive and 1 exclusive.
