How to use the Excel RAND function

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:

Excel RAND function 1 - How to use the Excel RAND function

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

Add a Comment

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