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

© 2022 Better Solutions Limited