In Google Sheet we can use RANDBETWEEN() function to generate the random number in a specified range. Like here in cell A2 we have used RANDBETWEEN() function to generate random number between 20 to 50.
=RANDBETWEEN(lower range, upper range)
You can create the list of random numbers in a specified range by dragging or copy paste the formula as follows.
RANDBETWEEN is a volatile function. This means that the result of this function keeps on changing based on the recalculation settings specified for the Google Sheet. In Google Sheet you can specify the Re-Calculation setting for this function with the below process.
- Go to File Menu
- Click Spreadsheet Settings
- Now in the Spreadsheet Settings pane go to Calculation. There you will find the available options to select how often you want the function to recalculate in this spreadsheet. Select the appropriate one as needed from On Change/On Change and every minute/ On change and every hour.
- Then click Save Settings.
- There can be duplicate random numbers generated while using the same RANDBETWEEN() function for multiple cells.