What does it do?

Returns a random integer number between the numbers you specify.

Formula breakdown:

=RANDBETWEEN(bottom number, top number)

What it means:

=RANDBETWEEN(10, 10000)


I use the RANDBETWEEN function all the time whenever I need to create a sample data set.

The cool thing about the RANDBETWEEN function is that if you don’t like the numbers that it has given you, you can press F9 in a cell and it will give you new numbers.  Try it out by downloading the sample workbook!

DOWNLOAD EXCEL WORKBOOK

We want to enter some random numbers from 10 to 10,000.

STEP 1: We need to enter the RANDBETWEEN function in a blank cell:

=RANDBETWEEN(

Randbetween Formula

 

STEP 2: The RANDBETWEEN arguments:

Bottom_number

What is your minimum value?

For our example it’s 10

=RANDBETWEEN(10,

Randbetween Formula

Top_number

What is your maximum value?

For our example it’s 10,000

=RANDBETWEEN(10, 10000)

Randbetween Formula

Apply the same formula to the rest of the cells by dragging the lower right corner downwards. Then drag it to the right to populate all the cells.

Randbetween Formula

Randbetween Formula

You now have all of the random numbers!

How to Use the Randbetween Formula in Excel

Randbetween2

 

HELPFUL RESOURCE:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Sumproduct & Weighted Averages   What does it do? It returns the sum of the products of corresponding ranges or arrays Formula breakdown: =SUMPRODUCT(array1, , ...) What it means: =SUMPRODUCT(this array, with that array…) A quick way to calculate the weighted average of two lis...
How To Use INDEX-MATCH Formula   What does it do? Searches the row position of a value/text in one column (using the MATCH function) and returns the value/text in the same row position from another column to the left or right (using the INDEX function) Formula breakdown: =INDEX(array, MATCH...
Excel Subtotal Function – Avoid Double Count... What does it do? It returns a Subtotal in a list or database Formula breakdown: =SUBTOTAL(function_num, ref1) What it means: =SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them, your list or range of data) ***Go to the bottom...
Evaluate Formulas Step By Step in Excel This is one of the coolest tricks I have seen in Excel, as there are countless times wherein I had a hard time understand formulas. Especially long and complex ones! Excel provides the way to evaluate your formula, and break it down step by step so that you can understand it! ...