Skip to content

How to Create Random Numbers in Google Sheets

In this article, I will show you how to create random numbers in Google Sheets. I will present four different methods.

Method 1 – Create Random Integer Values

To create random integers in Google Sheets, use the RANDBETWEEN function.

The RANDBETWEEN function allows you to create random integers between two specified values. For example, you would enter the following formula to create random integers between -100 and 100.

=RANDBETWEEN(-100, 100)

Once you’ve written the formula, you can use the fill handle to copy the formula down to create a set of random integers.

Method 2 – Create Random Decimals Between 0 and 1

Use the RAND function to create random decimals between 0 and 1 in Google Sheets.

The RAND function allows you to create random decimal values between 0 and 1. For example, you would enter the following formula to create random integers between 0 and 1.

=RAND()

Once you’ve written the formula, you can use the fill handle to copy the formula down to create a set of random decimals between 0 and 1.

Method 3 – Create Random Numbers With Decimals

To create random numbers in Google Sheets, use the RANDBETWEEN function in combination with the RAND function.

For example, you would enter the following formula to create random numbers between -100 and 100.

=RANDBETWEEN(-100, 100) + RAND()

The RANDBETWEEN function creates a random integer between -100 and 100, and the RAND function creates a random decimal between and 1. As a result, you get a random number containing decimals between -100 and 100.

Once you’ve written the formula, you can use the fill handle to copy the formula down to create a set of random numbers.

Method 4 – Create Rounded Random Numbers

To create rounded random numbers in Google Sheets, use these three functions.

  • RANDBETWEEN
  • RAND
  • ROUND

For example, you can write the following formula to create random numbers between 10 and 100 rounded to two decimal places.

=ROUND(RANDBETWEEN(-100, 100) + RAND(), 2)

The RANDBETWEEN and RAND function create the random number, and the ROUND function rounds the result to the specified number of decimal places.

Once you’ve written the formula, you can use the fill handle to copy the formula down to create a set of random numbers.

This Post Has One Comment

  1. I didn’t realize that there were so many ways to create random numbers! I also didn’t realize how many functions you might need to know! It just goes to show you that the more you know, the more you can do with spreadsheets!

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top