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) = 1
2	=RANDBETWEEN(1,10) = 2
3	=RANDBETWEEN(-10,10) = -3
4	=RANDBETWEEN(1,40) = 33
5	=ROUND(RAND()*(40-1)+1,0) = 23
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.