Excel RANDBETWEEN Function: Generate Random Numbers | Excel One Minute Quick Functions Explained

The RANDBETWEEN function in Excel returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated.

Syntax
RANDBETWEEN(bottom, top)
The RANDBETWEEN function syntax has the following arguments:
Bottom - Required. The smallest integer RANDBETWEEN will return.
Top - Required. The largest integer RANDBETWEEN will return.

Examples of RANDBETWEEN:
=RANDBETWEEN(20,60)
=RANDBETWEEN(2000,9000)

Multiple results with RANDBETWEEN:
This is the 2nd example in my video. To generate multiple random numbers in multiple cells, select your range of cells, enter the RANDBETWEEN function, and press CTRL + Enter to enter the same formula in all cells at one time.

#msexcel #microsoftexcel #chrismenardtraining

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[jaymzz]

Yoooo ! You've taught me so much on less than a min. I can't thank you enough. Hopefully you have more videos

[OzduSoleilDATA]

Soooo many uses for generating random data. Good stuff!

[einoconsult]

Thanks Chris, for the second example I am using RANDARRAY which is the same idea :)

[cchurcharnhem]

men, i cant get this to work. it just sas i have to few arguments but i did exactly as you shown

[janevanderpal]

My pc keeps saying "you've entered too few arguments for this function", no matter how large i make the interval. Does anyone know how to solve this?