RANDARRAY

Generates an array of random numbers between two values.

Sintaxia

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.


Adibideak

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

Informazio teknikoa

tip

This function is available since LibreOfficeDev 24.8.


Funtzio hau ez dago Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format estandarrean. Izen-espazioa honakoa da:

COM.MICROSOFT.RANDARRAY