Google Sheets-functie

RANDARRAY

Returns an array of random numbers between 0 and 1 or within a specified range.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

RANDARRAY([rows], [columns], [min], [max], [whole_number])

The RANDARRAY function generates a dynamic array of random numbers. You can specify the dimensions of the array, the range of values, and whether the results should be integers or decimals.

Argumenten

rowsoptioneelThe number of rows to return.
columnsoptioneelThe number of columns to return.
minoptioneelThe minimum number to return.
maxoptioneelThe maximum number to return.
whole_numberoptioneelTRUE for integers, FALSE for decimals.

Voorbeelden

=RANDARRAY(2, 2, 1, 10, TRUE)

Resultaat: {3, 8; 5, 2}

Generates a 2x2 array of random integers between 1 and 10.

Veelgestelde vragen

Why do the numbers change every time I edit the sheet?

RANDARRAY is a volatile function that recalculates whenever the worksheet changes.

Gerelateerde functies

RAND RANDBETWEEN SEQUENCE