RANDARRAY

Generates an array of random numbers between two limit values.

This function returns a dynamic array.

Syntaksi

RANDARRAY([Rows [; Columns [; Min [; Max [; Integers] ] ] ])

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 lower limit of the generated numbers. If omitted, the minimum value is 0.

Max: (optional) The upper limit of the generated numbers. If omitted, the maximum value is 1.

Integers: (optional) returns whole numbers (TRUE) or decimal numbers (FALSE). Default is FALSE.

Any of the optional arguments can be omitted. An optional argument requires all preceding separators to be present.

Esimerkki

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

Teknistä tietoa

Tämä funktio on käytettävissä LibreOfficeDev 24.8:sta alkaen.

This function is NOT part of the Open Document Format for Office Applications (OpenDocument) Version 1.4. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.RANDARRAY

RANDBETWEEN, RANDBETWEEN.NV, RAND, RAND.NV

RANDARRAY wiki page.