How to Generate Random Numbers in Excel Using RAND function & RANDBETWEEN Excel function - Tutorial

Learn how to generate random numbers in Excel using the RAND function and the RANDBETWEEN function in Excel as a random number generator. The random number functions in Excel, both the RAND function and the RANDBETWEEN function, are used to generate random numbers in Excel spreadsheets.

What is the RANDBETWEEN function in Excel?
Use the RANDBETWEEN formula to generate random numbers in Excel that are within a range that you set - for example, between 1 and 10.

What is the RAND function in Excel?
Use the RAND formula to generate random numbers in Excel that are less than 1. You'll use RAND()

Watch this free Excel tutorial to learn how to use the RAND formula and the RANDBETWEEN formula as a random number generator in a Microsoft Excel spreadsheet.

For another fun example of using an Excel random formula, take a look at how RAND was used in these tutorials:

Create bingo boards: https://youtu.be/lSKPadZyd-U

Shuffle letters to create a word scramble: https://youtu.be/LiSTBuPAORw

If you have Microsoft 365 or Office 2021, check out my tutorial on the new RANDARRAY function: https://youtu.be/CbyGKA3XxDg

And, If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: https://yacostasolutions.com/newsletter/

*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: https://yacostasolutions.com/MS365

The screen recording + editing was done using Techsmith Camtasia. You can check it out here: https://yacostasolutions.com/camtasia

Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out ?

To catch our Excel tutorials as they come out, subscribe to this channel by clicking: https://yacostasolutions.com/youtube

Thanks!

*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!

#YAcostaTutorials