An Overview of RANDBETWEEN Function | Microsoft Excel

The RANDBETWEEN function is one of the math and trigonometry functions in Microsoft Excel. It can be used as a standalone function as well as in collaboration with the other functions. This article will give you an overview of the RANDBETWEEN function in Excel.

Objectives

The RANDBETWEEN function generates a random integer number between a top value and a bottom value.

Syntax

=RANDBETWEEN(bottom, top)

Arguments

  • bottom: The lowest value you want to generate in a range.
  • top: The highest value you want to generate in a range.

Output

An integer numerical value.

Examples of RANDBETWEEN Function

Suppose, you want to generate some random integer numbers between 5 and 50. You can get those random numbers quite easily using the RANDBETWEEN function. Just use this formula:

=RANDBETWEEN(5,50)

Examples of RANDBETWEEN Function in Excel

Usage Guide of RANDBETWEEN Function

Step_1: Start with inserting an equal sign (=) in a blank cell.

Step_2: Then type RANDBETWEEN.

Step_3: Type open parenthesis “(“.

As you type the open parenthesis, Excel shows the syntax of the RANDBETWEEN function.

Step_4: Insert the bottom value of a number range.

You can directly insert a number or a cell address that contains a number.

Step_5: Then insert a comma (,).

After inserting the comma, Excel will ask you for the second argument which is the top number of a range.

Usage Guide of RANDBETWEEN Function in Excel

Step_6: Now insert the top number of the range.

Step_7: Finally, add a closing parenthesis “)” to complete the syntax.

Usage Guide of RANDBETWEEN Function in Excel

Step_8: Now, press ENTER.

The RANDBETWEEN function will return an integer number in the range 5 to 50.

Usage Guide of RANDBETWEEN Function in Excel

Step_9: To generate more random numbers, click and hold the left mouse button. Then drag the Fill Handle down.

Usage Guide of RANDBETWEEN Function in Excel

Release the left mouse button now. You will get a plethora of random integer numbers between 5 and 50.

Recalculate Random Numbers

To recalculate the random numbers using the RANDBETWEEN function,

Step_1: Select the Formulas tab.

Step_2: In the Calculation group, select the Calculate Now command.

Recalculate Random Numbers

Or you can press the F9 button to regenerate the random integer numbers.

Availability

  • Excel for Microsoft 365
  • Excel 2016
  • Excel for Microsoft 365 for Mac
  • Excel 2016 for Mac
  • Excel for the web
  • Excel 2013
  • Excel 2021
  • Excel 2010
  • Excel 2021 for Mac
  • Excel 2007
  • Excel 2019
  • Excel for Mac 2011
  • Excel 2019 for Mac
  • Excel Starter 2010

Remarks

  • The RANDBETWEEN function regenerates each time a workbook is opened or any change occurs.
  • Press the F9 key to recalculate the random numbers.

Conclusion

The RANDBETWEEN function is one of the math and trigonometry functions in Excel. If you have any questions regarding the RANDBETWEEN function, please comment below. Thanks!

(Visited 16 times, 1 visits today)

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *