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

Veröffentlicht am: 17 September 2021
auf dem Kanal: 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!


Auf dieser Seite können Sie das Online-Video Excel RANDBETWEEN Function: Generate Random Numbers | Excel One Minute Quick Functions Explained mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Chris Menard 17 September 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 25,930 Mal angesehen und es wurde von 177 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!