Pinterest Pixel

RANDBETWEEN Function

  What does it do? Returns a random integer number between the numbers you specify. Formula breakdown:... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

RANDBETWEEN Function | MyExcelOnline RANDBETWEEN Function | MyExcelOnline

 

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!

RANDBETWEEN Function | MyExcelOnline

Download excel workbookRandbetween.xlsx

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 Function for Excel Dates

 

STEP 2: The RANDBETWEEN arguments:

Bottom_number

What is your minimum value?

For our example it’s 10

=RANDBETWEEN(10,

RANDBETWEEN Function for Excel Dates

Top_number

What is your maximum value?

For our example it’s 10,000

See also  Correlation in Excel - With Examples!

=RANDBETWEEN(10, 10000)

RANDBETWEEN Function for Excel Dates

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 Function for Excel Dates

RANDBETWEEN Function for Excel Dates

You now have all of the random numbers!

How to Use the Randbetween Formula in Excel

 

 

 

 

If you like this Excel tip, please share it
RANDBETWEEN Function | MyExcelOnline RANDBETWEEN Function | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...