Google Sheets Function: RANDBETWEEN

The RANDBETWEEN function generates a random integer between two inclusive values.

Usage:

=RANDBETWEEN(low, high)

Usage Example

To generate whole numbers ranging from 10 to 30, enter:

=RANDBETWEEN(10,30)