Excel: Generate Random Number Between Range


There are two ways to generate a random number between a range in Excel:

Method 1: Use RANDBETWEEN() to Generate Random Integer in Range

=RANDBETWEEN(1, 10)

This particular formula will generate a random integer between 1 and 10.

Method 2: Use RAND() to Generate Random Number with Decimal in Range

=RANDBETWEEN(5, 14) + RAND()

This particular formula will generate a random value with decimal places between 5 and 15.

The following examples show how to use each method in practice.

Step 1: Use RANDBETWEEN() to Generate Random Integer in Range

We can use the following formula to generate a random number between 1 and 10:

=RANDBETWEEN(1, 10)

We’ll type this formula into cell A1 and press Enter:

The RANDBETWEEN() function generated a random integer of 9.

We can also click and drag this formula down to other cells in the same column to generate a list of random integers between 1 and 10:

Excel generate random integer between range

Each of the cells in column A now contains a random integer between 1 and 10.

Example 2: Use RAND() to Generate Random Number with Decimal in Range

We can use the following formula to generate a random number with decimal places between 5 and 15:

=RANDBETWEEN(5, 14) + RAND()

We’ll type this formula into cell A1 and press Enter:

Excel generate random value between range with decimal places

The formula generated the value 8.22564.

Here’s how this formula actually works:

  • First, RANDBETWEEN() generates a random integer between 5 and 14.
  • Then, RAND() generates a random decimal between 0 and 1 and adds it to the integer.

The result is a random value with a decimal between 5 and 15.

Note that we could also drag and fill this formula down to other cells in column A:

Each of the cells in column A now contains a random value with a decimal between 5 and 15.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Randomly Select Cells Based on Criteria in Excel
How to Select a Random Sample in Excel
How to Calculate Average If Between Two Values in Excel

Featured Posts

Leave a Reply

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