Returns a uniformly random integer between two values, inclusive. Learn more
In Google Sheets, the function RANDBETWEEN is a built-in function used to generate a random integer between a specified range.
Here's how the RANDBETWEEN function works:
The "low" parameter specifies the lower end of the range. The "high" parameter specifies the upper end of the range. The RANDBETWEEN function generates a random integer greater than or equal to the "low" value and less than or equal to the "high" value. The generated random number will be within the specified range, inclusive of both the lower and upper bounds.
For example, if you use the formula =RANDBETWEEN(1, 10), it will generate a random integer between 1 and 10, including 1 and 10. The resulting random number could be 1, 5, 10, or any other integer between 1 and 10.