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 (Windows) or Command+Option+Enter (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