RANDARRAY

Generates an array of random numbers between two values.

Sintaxe

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.


Exemplos

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

Informação técnica

tip

Esta função está disponível desde o LibreOfficeDev 24.8.


Esta função não faz parte do padrão Open Document Format for Office Applications (OpenDocument) Versão 1.3. Parte 4: Formato de Fórmula Recalculada (OpenFormula). O espaço de nomes é

COM.MICROSOFT.RANDARRAY