RANDARRAY

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

Returns the array of random numbers between two values (>=min and <max).

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

REMARKS
* This function was added in Excel 2021.
* This function can create a Dynamic Array Formula.
* This is a Volatile function and will change everytime a cell on the worksheet is calculated.
* This function can return repeated values.
* If "rows" and "columns" are not provided then a single random number >=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 between zero and one (>=0 and <1).
* You can use the RANDBETWEEN function to return a random integer between two values (>=bottom and <=top).
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=RANDARRAY() = 0.57
2=RANDARRAY(1, 1) = 0.39
3=RANDARRAY(1, 1, 10, 20) = 18.25
4=CHAR(RANDARRAY(1, 1, 65, 90, TRUE)) = Q
5=RANDARRAY(1, 1, 10%, 50%, FALSE) = 48.82%
6=RANDARRAY(1, 1, DATE(2024, 1, 1), DATE(2024, 12, 31), TRUE) = 14 September 2024
7=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.
5 - Return a random letter.
6 - Return a random percentage between 10% and 50%.
7 - Return a random date in the year 2024. The serial number will be returned so you will need to apply a date format.

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