Generate Random Numbers Using RAND + RANDBETWEEN functions in Excel – Tutorial

We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)

Excel tutorial on how to generate random numbers in Excel. We’ll look at 2 ways of creating random numbers. We’ll look at how to use the RANDBETWEEN function and how to use the RAND function to do this.

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()

About Y. Acosta

Yil's (pronounced like "Jill") passion for Excel spreadsheets can be traced back to her days in marketing, where she spent significant time working on analytics. As a content creator, she now specializes in Excel spreadsheet tutorials. Make sure to visit the About page to learn more.

Leave a Reply Cancel reply