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)
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.
Step_6: Now insert the top number of the range.
Step_7: Finally, add a closing parenthesis “)” to complete the syntax.
Step_8: Now, press ENTER.
The RANDBETWEEN function will return an integer number in the range 5 to 50.
Step_9: To generate more random numbers, click and hold the left mouse button. Then drag the Fill Handle down.
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.
Or you can press the F9 button to regenerate the random integer numbers.
Availability
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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!
