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

Published: 17 September 2021
on channel: Chris Menard
25,930
177

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 --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

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!


On this page of the site you can watch the video online Excel RANDBETWEEN Function: Generate Random Numbers | Excel One Minute Quick Functions Explained with a duration of hours minute second in good quality, which was uploaded by the user Chris Menard 17 September 2021, share the link with friends and acquaintances, this video has already been watched 25,930 times on youtube and it was liked by 177 viewers. Enjoy your viewing!