RAND function in excel is also known as the random function in excel, this function generates a random value which is greater than 0 but is lesser than 1 and the distribution is even among those numbers if used on multiple cells, the important thing to remember is that when we recalculate the formula the result changes.
Syntax: =RAND ()
The RAND function syntax has the following arguments:
- There are no parameters or arguments for the RAND function.
Example: Let’s look at some Excel RAND function examples and explore how to use the RAND function as a worksheet function in Microsoft Excel:
Syntax: =RAND ()
Result:
Based on the Excel spreadsheet above, the following RAND examples would return:
Syntax: =RAND()
Result: 0.061575404
0.40816607
0.712746447
Syntax: =RAND()*10
Result: 1.61510292
5.769414803
4.431661183
Syntax: =RAND()*20
Result: 7.242902532
4.194692168
7.477653983
Syntax: =RAND()*55
Result: 51.10060375
19.7617888
8.868706226
Syntax: =RAND()*100
Result: 68.51480149
57.01389733
57.90954991
Syntax: =0.5+(1.5-0.5)*RAND()
Result: 1.209810392
0.698182592
0.503851865
Syntax: =INT(RAND()*200)
Result: 75
51
41
Note:
- RAND calculates a new value each time the worksheet is calculated. To stop random numbers from being updated, copy the cells that contain RAND to the clipboard, then use Paste Special > Values to convert to text.
- To get a random number that doesn’t change when the worksheet is calculated, enter =RAND() in the formulas bar and then press F9 to convert the formula into its result.
- To generate a set of random numbers in multiple cells, select the cells, enter RAND() and press control + Enter.
- To generate a random number between a and b, use this formula: RAND() * (b – a) + a
