# How to Use the RAND Function in Excel – 5 Examples

This is an overview.

## The RAND Function in Excel

This function returns a random number between 0 and 1.

• Syntax
`=RAND()`

• Arguments

This function doesn’t require any argument.

### Example 1 – Generate Random Numbers Between 0 and 1

Use:

`=RAND()`

5 random numbers were generated.

### Example 2 – Generating Random Numbers Between 0 and 100

Use the formula:

`=RAND()*100`

5 random numbers  between 0 and 100 were generated.

### Example 3 – Using the RAND Function to Generate Random Numbers Between Two Specific Numbers in Excel

Find random values between two numbers.

`=RAND()*(b-a)+a`
• Replace a and b in the formula with numbers. The difference between the two numbers is multiplied by the random value generated by the RAND function. The starting number is added to the output.

Random values between 5 and 6 were generated.

### Example 4 – Generate Random Integer Numbers

• Use a nested formula:
`=INT(RAND())`
• To generate numbers between 0 and 100, the formula is:
`=INT(RAND()*100)`

5 random integers between 0 and 100 were generated.

### Example 5 – Use the RAND Function to Generate Random Numbers Up to a specified Decimal in Excel

• To generate numbers up to 2 decimal points, use the formula:
`=ROUND(RAND()*100,2)`

A random value between 0 and 100 with up to 2 decimal points is generated.

You can select other decimal points:

## Practice Workbook

Download the workbook.

<< Go Back to Excel Functions | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Shakil Ahmed

My name’s Shakil. My articles are targeted to support you in enriching knowledge regarding different features related to Microsoft Excel. I am fond of literature, hope some knowledge from them will help me providing you some engaging articles even though some weary technical terms.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF