Google Sheets provides a simple function to generate random numbers inside your spreadsheet without having to leave the document or install an add-on. The function returns a random integer between two values. Here’s how to use it.
By default, the
RANDfunction only generates a number between 0 (inclusive) and 1 (exclusive), whereas
RANDBETWEEN lets you specify a range of numbers. While you could modify the function to generate other ranges, the
RANDBETWEENfunction is a much simpler way to accomplish this.
Click on a cell where you want to insert a random number and type
=RANDBETWEEN(<Low>, <High>) but replace
<High> with the range in which you want the random number to fall.
For example, if you want a random number between 1 and 10, it should look like this:
After you fill in the range, press the Enter key. The random number will populate the cell where you entered the formula.
If you want to use a number from another cell in your spreadsheet, all you have to do is enter the cell number instead of a low or high number.
RANDBETWEEN are considered volatile functions, meaning they don’t retain the data in the cell forever. So, when you’re using either of the functions, they recalculate a new number each time the sheet changes.
If you want to change the interval in which your random number is recalculated, open up File > Spreadsheet Settings, click on the “Calculation” tab, and then choose how often you want the function to recalculate from the drop-down menu.
You can select “On Change” (default), “On Change and Every Minute,” or “On Change and Every Hour.” Click “Save Settings” to return to your spreadsheet.
Source: How to Generate Random Numbers in Google Sheets
By Brady Gavin
Techylawyer and its authors do not claim to have written this article, we acknowledge the works of the original author