The RANDARRAY function is a function added in 2019 to set random numbers in multiple cells.
It is a multi-cell version of the RANDBETWEEN function.
How it works
=RANDARRAY(rows,columns,min,max,whole_number)
| Name | Omission | Explanation |
|---|---|---|
| rows | 1 | Number of vertical cells from which to obtain random numbers. |
| columns | 1 | Number of cells in the horizontal direction from which to obtain random numbers. |
| min | 0 | Lower limit of random numbers. |
| max | 1 | Upper limit of random numbers. |
| whole_number | FALSE | Whether the decimal point is rounded down or not. TRUE. truncate. Obtained as an integer.) FALSE.Do not truncate.Obtained with a fractional number. |
Demonstrate
Enter a function in the top left most cell that sets a random value.
You will then get a random value for the specified cell range.
This value will change to a new value when the file is reopened or the cell is taken out of input mode.
If you want to fix the value, use Paste Value.
Comparison with RANDBETWEEN function
If you have random numbers built into your sheet as formulas and do not want them to be broken, or if you want to generate many random numbers at once, the
RANDARRAY function is superior.
If you are preparing a small number of random numbers for a one-time use, the
RANDBETWEEN function is appropriate.
---