Parameter List
Syntax
RANDARRAY(
[rows]
, [columns]
, [min]
, [max]
, [whole_number]
)[optional] rows
The number of rows in the array. For example: 5. If omitted, defaults to 1.
[optional] columns
The number of columns in the array. For example: 3. If omitted, defaults to 1.
[optional] min
The minimum value for the random numbers. For example: 1, 0, -10. If omitted, defaults to 0.
[optional] max
The maximum value for the random numbers. For example: 100, 1, 10. If omitted, defaults to 1.
[optional] whole_number
Whether to return integers or decimals:
FALSE(default) - Return decimal numbersTRUE- Return whole numbers (integers)
More details
RANDARRAY generates a dynamic array of random numbers that recalculates whenever the worksheet calculates. The function can produce decimal numbers between 0 and 1 (default), or integers/decimals within a specified range. Each cell in the array contains an independent random value.