RANDARRAY

The RANDARRAY function returns an array of random numbers based on your specifications. You specify the number of rows and columns, minimum and maximum values, and whether to provide whole numbers or decimal values.

RANDARRAY(number-of-rows, number-of-columns, min-value, max-value, result-type)

number-of-rows: The number of rows to return.

number-of-columns: The number of columns to return.

min-value: The minimum value to return.

max-value: The maximum value to return.

result-type: A Boolean value of either TRUE or FALSE.

real values (FALSE or omitted): Return real values.

integer values (TRUE): Return integer values.

Notes

  • Values returned are greater than or equal to the given minimum value and less than or equal to the maximum value.

Examples

=RANDARRAY(2,3,5,10, TRUE) returns an array of random numbers like below:

A

B

C

1

9

7

8

2

7

10

8

=RANDARRAY(3,4,1,5,FALSE) returns an array of random numbers like below:

A

B

C

D

1

2.97906008

1.46739522

3.64284618

4.04199489

2

3.85540489

1.19269692

2.44042386

2.9864392

3

1.45970074

3.91585444

4.39522683

1.39931036

See alsoRANDBETWEEN
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
உதவியாக இருந்ததா?
எழுத்தின் அளவு: 250
அதிகபட்ச எழுத்தின் அளவு: 250
உங்கள் கருத்திற்கு நன்றி.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.