RANDARRAY

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.

note

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).

Τεχνικές πληροφορίες

tip

This function is available since LibreOfficeDev 24.8.


Αυτή η συνάρτηση δεν αποτελεί μέρος του προτύπου Open Document Format for Office Applications (OpenDocument) Έκδοση 1.3. Μέρος 4: Μορφή επανυπολογισμένου τύπου (OpenFormula). Ο χώρος του ονόματος είναι

COM.MICROSOFT.RANDARRAY