Google Sheets allow its users to add a random number in the spreadsheet without having to install an add-on or leaving the sheet. This function gives a random value between the two integers in return. In this guide, you will learn how to use this function.
also, learn HOW TO CHANGE RULER UNITS IN WORD
We will use the RANDBETWEEN function to produce a random number. By Default, RAND function only produces a number between 1’s or 0’s while the RANDBETWEEN function lets you specify from a wide range of numbers. This function is a lot easier and simpler to use.
Generate Random Numbers in Google Sheets
Follow the guide to use it:
- Launch the Google Sheets and open a new or already existing spreadsheet.
- Now click on the cell that you want to generate random number in and type the command =RANDBETWEEN (<Low>, <High>) and instead of Low and High use the integers to fall. For example =RANDBETWEEN(2,15)
- When you’re done typing the command and inserting number, press enters and a random number in-between the values will be generated in the cell.
If you want to use the number from different cells instead of the numbers that you inserted yourself, just type in the cell number in the Low and High place.