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 |
|
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