RANDARRAY

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

Returns the array of random numbers between 0 and 1.

rows(Optional) The number of rows to be returned.
columns(Optional) The number of columns to be returned.
min(Optional) The minimum number you would like returned.
max(Optional) The maximum number you would like returned.
integer(Optional) A logical value indicating whether to return a whole number or a decimal value:
True = an integer number
False = a decimal number (default)

REMARKS
* Added in Excel 2021.
* This function can create a Dynamic Array Formula.
* This function is Volatile and will change everytime a cell on the worksheet is calculated.
* If "rows" and "columns" are not provided then a single random number between 0 and 1 is returned.
* If "min" is left blank, then 0 is used.
* If "max" is left blank, then 1 is used.
* If "integer" is left blank, then False is used.
* You can use the RAND function to return a random number >=0 and <1.
* You can use the RANDBETWEEN function to return a random number between two specified numbers.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=RANDARRAY() = 0.32
2=RANDARRAY(1,1) = 0.28
3=RANDARRAY(1,1,10,20) = 16.24
4=RANDARRAY(2,1) = { 0.58, 0.95 }

1 - Return a random number between 0 and 1.
2 - Return a random number between 0 and 1.
3 - Return a random number between 10 and 20.
4 - Return two random numbers between 0 and 1.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top