RANDBETWEEN

RANDBETWEEN(bottom, top)

Returns the random number between two specified numbers (inclusive).

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 function is Volatile and will change everytime a cell on the worksheet is calculated.
* You can use the RAND function to return a random number >=0 and <1.
* You can use the RANDARRAY function to return the array of random numbers between 0 and 1.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=RANDBETWEEN(1, 4) = 4
2	=RANDBETWEEN(1, 10) = 8
3	=RANDBETWEEN(-10, 10) = 4
4	=RANDBETWEEN(1, 40) = 25
5	=ROUND(RAND()*(40-1)+1, 0) = 9
6	=RANDBETWEEN("some text", 40) = #VALUE!
7	=RANDBETWEEN(1, "some text") = #VALUE!

1 - This returns a random number between 1 and 4.
2 - This returns a random number between 1 and 10.
3 - This returns a random number between -10 and 10.
4 - This returns a random number between 1 and 40.
5 - This returns a random number between 1 and 40 by using the RAND function.