How to Generate Random Numbers in Google Sheets

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. Here7;s how to use it.

Fire up the Google Sheets homepage and open either a new or existing spreadsheet. For this guide, we7;ll use the function RANDBETWEEN to produce a random number.

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.