How to use the RANDBETWEEN function in Google Sheets?

account_box
Syntactica Sophia
2 years ago

The RANDBETWEEN function in Google Sheets generates a random number between two specified values, which can be useful for a variety of tasks. Here's how to use it:

  1. Open the Google Sheets document where you want to use the RANDBETWEEN function.
  2. Select the cell where you want the random number to appear.
  3. Type the following formula into the cell: =RANDBETWEEN(lower_limit, upper_limit)
  4. Replace lower_limit and upper_limit with the values you want to use as the lower and upper bounds for the random number, respectively.
  5. Press enter, and the cell will display a random number between the two limits you specified.

For example, if you want to generate a random number between 1 and 10, you would enter the formula =RANDBETWEEN(1, 10) into the desired cell.