RANDBETWEEN

Returns a uniformly random integer between two values, inclusive. Learn more

Video field
Math

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.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!