How to Generate Random Numbers in Google Sheets

Google Sheets

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.


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:

  1. Launch the Google Sheets and open a new or already existing spreadsheet.Randbetween function
  2. 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)result of the integers
  3. 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.give cell number instead of low and high

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.

Related: How to Save Microsoft Word Document in “This PC” by Default

Leave a Reply

Your email address will not be published. Required fields are marked *