Returns an array of random values in the given cell range. The minimum, maximum and type of values to be returned can also be specified.
Syntax
row: Number of rows to be filled with the random array. Defaults to 1 if omitted. Eg., 3
column: Number of columns to be filled with the sequential array. Defaults to 1 if omitted. Eg., 2
min: The lowest value you want in the array. Defaults to 0 if omitted. Eg., 1
max: The highest value you want in the array. Defaults to 1 if omitted. Eg., 10
type: Logical expression that specifies the type of value to return. Defaults to FALSE if omitted.
If TRUE, the function returns whole numbers.
Remarks
The result values will change every time a function is recalculated.
Examples
Formula |
=RANDARRAY(3;2;1;10) |
=RANDARRAY(2;3;1;50;TRUE) |
=RANDARRAY(1;3;-1;1) |
Possible Errors
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com