RANDARRAY
Description
Returns an array of random numbers. This function is intended for use with
unconstrained arrays. To submit the formula, use the unconstrained keyboard shortcut
Ctrl+Alt+Enter (on Windows) or Command+Option+Enter (on Mac).
Syntax
RANDARRAY([
rows
], [
columns
], [
min
], [
max
],[
whole_number
])
- rows: The number of rows to return. If you don't specify a value, the function returns a single decimal value between 0 and 1.
- columns: The number of columns to return. If you don't specify a value, the function returns a single decimal value between 0 and 1.
- min: The lowest possible random number to return. This number is inclusive. (The value might be returned as a result.) If you omit the argument, the function uses 0 as the value.
- max: The highest possible random number to return. This number is inclusive. (The value might be returned as a result.) If you omit the argument, the function uses 1 as the value.
- whole_number: A logical value that specifies whether to return whole numbers or decimal values. The default is FALSE (decimal value).
Related Functions
RAND
RANDCONST
SEQUENCE