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 not an integer, it is truncated.
* If "top" is not an integer, it is truncated.
* 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

	A
1	=RANDBETWEEN(1,4) = {1,2,3,4}
2	=RANDBETWEEN(-10, 10) = 7.0
3	=RANDBETWEEN(2, 2) = 2.0
4	=RANDBETWEEN(1, 1.9) = 1.0
5	=RANDBETWEEN(1,2.9) = {1,2}
6	=RANDBETWEEN(1.1, 2.9) = 2.0
7	=RANDBETWEEN(1.5, 1.9) = 2.0
8	=RANDBETWEEN(2.1, 2.3) = 3.0
9	=ROUND(RAND()*(40-1)+1, 0) = 4.0
10	=RANDBETWEEN(3, 2) = #NUM!
11	=RANDBETWEEN("some text", 40) = #VALUE!

1 - This returns a random number between 1 and 4.
2 - This returns a random number between -10 and 10.
3 - This always returns the number 2.
4 - This always returns the number 1.
5 - This can return 1 or 2.
6 - ??
7 - This always returns the number 3.
8 - This returns a random number between 1 and 40 by using the RAND function.
9 - If "top" < "bottom", then #NUM! is returned.
10 - If any of the values are non numerical then #VALUE! is returned.