RANDBETWEEN Function in Excel: Generating Random Numbers Between a Range

Learn how to use the RANDBETWEEN function in Excel to generate random numbers or dates between a specified range. Understand the concept of Freezing Panes and why it's needed when using the RANDBETWEEN function. A beginner's guide to understanding the powerful tool of Excel functions.


Tired of nonsense pricing of DocuSign?

Start taking digital signatures with BoloSign and save money.

Generating random numbers is a common need in Excel and the RANDBETWEEN function makes it easy to do. This function will generate a random number between two values that you provide. This is an especially helpful tool when you need to generate a list of numbers for samples, experiments or testing.

The syntax for the RANDBETWEEN function is =RANDBETWEEN(bottom, top). Bottom is the lower range of the number you want to generate, while top is the higher range. For example, if you want to generate a number between 1 and 10, your formula would be =RANDBETWEEN(1,10).

It's important to note that when you use the RANDBETWEEN function, Excel will generate a new random number every time you calculate the sheet. This can lead to unexpected results. To prevent this, you can use the Freeze Panes option to freeze the area where the RANDBETWEEN function is located. This will make sure that the value generated by the function stays the same until you remove the freeze.

In addition to generating random numbers, the RANDBETWEEN function can also be used to generate random dates. To do this, you just need to replace the bottom and top values with dates instead of numbers. For example, if you wanted to generate a random date between Jan 1, 2020 and Dec 31, 2020, the formula would be =RANDBETWEEN("1/1/2020","12/31/2020").

In conclusion, the RANDBETWEEN function is an easy and effective way to generate random numbers or dates in Excel. You can use this function to quickly generate samples, tests or experiments without having to manually enter a long list of numbers or dates.


Paresh Deshmukh

Co-Founder, BoloForms

6 Mar, 2023

Take a Look at Our Featured Articles

These articles will guide you on how to simplify office work, boost your efficiency, and concentrate on expanding your business.