< Go Back

Excel RANDBETWEEN Function

Excel RANDBETWEEN Function

The RANDBETWEEN function is used to generate random numbers in Excel. And it continues to do so every time a recalculation occurs on the same worksheet. This means that a new random number is generated after every recalculation.

Formula

= RANDBETWEEN (bottom, top)

Arguments

The arguments below can be found in the Excel RANDBETWEEN function.

bottom – this is the integer which represents the smallest random integer that will be returned by the RANDBETWEEN function. It is the lowest value in the range.

top – this, on the other hand, is the higher value in the range. It represents the largest random integer that will be returned by the function.

Explanation

The RANDBETWEEN function returns an integer between the top and bottom values. This means that if, for instance, we have a range of 10 and 20, the function will generate any number between these two values.

Example

We take a look at the scenario of generating the different values between two years, “Year 1” and “Year 2” using the RANDBETWEEN function.

Figure 1. Excel shows the bottom and top integers for each year range.

Step 1

Enter the syntax for the RANDBETWEEN function in excel, which in this case is, “=RANDBETWEEN(A3, B3)”. The syntax returns the first random number between 20 and 30.

Figure 2. The Excel RANDBETWEEN function returns a random number.

Step 2

Do a drag down of the “Result” cell. This action returns all the random numbers of each cell.

Figure 3. The Excel RANDBETWEEN function returns all random numbers.

Step 3

Remember we said that the RANDBETWEEN function returns a different random integer every time a calculation is done.

In this regard, you can create a new column, “Result 2”, to test this out.

Figure 4. A new column for testing the RANDBETWEEN function.

Step 4

Enter the same formula in any of the cells. As you would see, the function returns a completely different integer for each column.

Figure 5. The Excel RANDBETWEEN function returns a completely different set of integers.

Excel RANDBETWEEN Function Notes

  •        A click of an existing RANDBWETWEEN formularized cell in Excel changes the numbers in it every time.
  •        If you’d like to let a certain cell remain constant, simply press the F9 button after using the RANDBETWEEN function in the cell.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar