RANDBETWEEN |
RANDBETWEEN(bottom, top) |
Returns the random integer between two values (>=bottom and <=top). |
bottom | The smallest integer that will be returned. |
top | The largest integer that will be returned. |
REMARKS |
* Both the values for "bottom" and "top" are inclusive. * This is a Volatile function and will change everytime a cell on the worksheet is calculated. * If "bottom" is a decimal, then you could get a value outside the range. * If "top" is a decimal, then you could get a value outside the range. * If "bottom" > "top", then #NUM! is returned. * You can use the RAND function to return a random number between zero and one (>=0 and <1). * You can use the RANDARRAY function to return the array of random numbers between two values (>=min and <max). * You can use the ROUND function to return the number rounded to a specified number of digits. * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
1 - This returns a random number between 1 and 4. 2 - This returns a random number between -5 and 5. 3 - This will always return the number 2. 4 - This will always return the number 1. 5 - This will return the number 1 or 2. 6 - This will return the number 9 or 10. 7 - This will return the number 9 or 10. 8 - This will always return the number 2. This value is outside the range. 9 - This will always return the number 2. This value is outside the range. 10 - This will always return the number 3. 11 - This returns a random number between 1 and 40 (using the RAND function). 12 - If "top" < "bottom", then #NUM! is returned. 13 - If any of the values are non numerical then #VALUE! is returned. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top