LibreOfficeDev 24.8 laguntza
Generates an array of random numbers between two values.
RANDARRAY(Rows, Columns, Min, Max, Whole number)
Rows: (optional) the number of rows to return. If omitted, the value is 1.
Columns: (optional) the number of columns to return. If omitted, the value is 1.
Min: (optional) the minimum number in the array. If omitted, the minimum value is 0.
Max: (optional) the maximum number in the array. If omitted, the maximum value is 1.
Whole number: (optional) returns whole numbers (TRUE) or decimal numbers (FALSE). Default is FALSE.
If Rows and Columns are greater than 1, the RANDARRAY function must be entered as an array formula.
{=RANDARRAY(10,4,10,50,1)} returns an array of 10 rows, 4 columns with minimum value 10 and maximum value of 50 of whole numbers (integers).
COM.MICROSOFT.RANDARRAY