Knowing how to generate random numbers in your spreadsheet can be extremely useful. Thankfully, this can be done with ease in Google Sheets. You can use two functions in Google Sheets to create a random number. These are the RAND and RANDBETWEEN functions.