RANDARRAY
Returns an array of random numbers
Syntax
RANDARRAY([rows], [columns], [min], [max], [whole_number])
Parameters
- rows: Optional. The number of rows to return (default 1)
- columns: Optional. The number of columns to return (default 1)
- min: Optional. The minimum value (default 0)
- max: Optional. The maximum value (default 1)
- whole_number: Optional. TRUE for whole numbers, FALSE (default) for decimal
Example
=RANDARRAY(5, 3, 1, 100, TRUE)