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