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