An Overview of RAND Function | Microsoft Excel
The RAND 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 RAND function in Excel.
Objectives
The RAND function generates a random positive number in the range 0 ≤ x < 1.
Syntax
=RAND()
Arguments
- It has no argument
Output
A positive fraction number in the range 0 ≤ x < 1.
Examples of RAND Function
Suppose, you want to generate some random fraction numbers greater than or equal to 0 and less than 1. You can simply use the RAND function to achieve this. Use this formula:
=RAND()
Usage Guide of RAND Function
Step_1: Start with inserting an equal sign (=) in a blank cell.
Step_2: Then type RAND.
Step_3: After that, type a pair of open and close parenthesis “()”.
Step_4: Press ENTER.
The RAND function will return a random positive fraction number within 0 and 1.
Step_5: To generate more random numbers, click and hold the left mouse button. Then drag the Fill Handle down.
Final Result
Release the left mouse button now. It will get a plethora of random positive fraction numbers.
Recalculate Random Numbers
To recalculate the random numbers using the RAND 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 numbers.
Availability
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Remarks
- The RAND function doesn’t require any argument.
- It regenerates each time a workbook is opened or any change occurs.
- Press the F9 key to recalculate the random numbers.
Conclusion
The RAND function is one of the math and trigonometry functions in Excel. If you have any questions regarding the RAND function, please comment below. Thanks!