Go Back

Random number between two numbers

Figure 1. of the Randbetween Function in Excel.

The Excel Randbetween Function determines a random  number integer between the number range we have specified. This tutorial will step through the process of generating random numbers that fall between two specified values

Generic Formula

=RANDBETWEEN(lower,upper)

The Randbetween operation syntax consists of the following arguments;

  • Lower (required) – The smallest number integer within the range we have specified.
  • Upper (required) – The largest number integer within the range we have specified.

How to use the Randbetween Function in Excel.

In the event that we are required to generate random number integers between 1-100, follow these simple steps;

  1. Select any cell in our Excel sheet. In the example illustrated below we have selected cell A1.
  2. In cell A2, insert the following formula =RANDBETWEEN(1,100)

Figure 2. of the Randbetween Function in Excel.

  1. Copy the operation syntax down the entire cells in the column for more results (as illustrated above)

In the event that we are required to generate random number integers between (40-85), follow these simple steps;

  1. Select any cell in our Excel sheet. In the example illustrated below we have selected cell A1.
  2. Input the formula syntax =RANDBETWEEN(40,85) into the formula bar for cell A1, then press Enter.

Figure 3. of the Randbetween Function in Excel.

  1. Copy the operation syntax down the entire cells in the column for more results (as illustrated above)

Note

The Excel RANDBETWEEN function will by default, generate new random number integers whenever we effect a change on our worksheet. This includes any editing made on our worksheet, also also when we are simply opening our worksheet.

Figure 4. of Final Result

Instant Connection to an Expert through our Excelchat Service

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

I have a list of random generated numbers from 1 through 100. I need a formula that will list the number of instances for each number 1 through 100. For example: My list generates 1000 random generated numbers between 1 and 100. I want to know how many times the number 50 is resulted from the 1000 random generated numbers.
Solved by V. D. in 13 mins
I need to generate two random numbers that cannot be equal. The number range is between 1 and 5. Currently I am using the Randbetween formula in two side by side cells. But I need advice on how to make sure they are never equal.
Solved by X. W. in 21 mins
GENERATE A LIST OF 20 UNIQUE RANDOM NUMBERS BETWEEN 1 AND 100.
Solved by D. H. in 29 mins

Leave a Comment

avatar