## What Is RAND Function In Excel?

The

RandomorRAND Excel functiongenerates random values greater than 0 but less than 1. The distribution is even among those numbers if used on multiple cells. Every time we open the worksheet or refresh the formula, the result changes.

For example, when we type **=RAND()**, it generates a number like 0.902158.

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked

For eg:

Source: RAND Excel Function (wallstreetmojo.com)

##### Table of contents

### Key Takeaways

- The
**RAND Excel function**generates random numbers from 0 to 1, by default. However, we can generate numbers within any desired range, such as 0 to 100, 45000 to 98000, etc. - To calculate the random numbers between two numbers, we use the formula
**=a+ (b-a)*RAND().**Here, a & b are integer values to generate numbers in-between them. - To generate a set of random numbers in multiple cells, we must select the cells, enter
**RAND(),**and then press the “**Ctrl + Enter**” keys.

### RAND Formula Excel And Explanation

#### RAND Excel Formula

The syntax of the **RAND Excel Formula **is,

The **RAND formula in Excel** has no parameters or arguments.

#### Explanation of the RAND Excel Function

- The
**RAND function**is categorized as the “**Math & Trig**” function in Excel. - It returns a random number between 0 and 1.
- The
**RAND function**in Excel will generate a new random number greater than or equal to 0 and less than 1, each time your Excel sheet is refreshed.

### How To Use RAND In Excel?

The **RAND In Excel function** is very simple and easy to use.

- We can insert the formula from the “
**Formulas**” tab from the “**Math & Trig**” group. - We can enter in the worksheet manually as
**=RAND(),**and - We can use it as a
**VBA function**.

#### RAND Excel Function As A Worksheet Function

The ways to enter the **RAND function** in the worksheet directly are as follows:

- One way, type
**=RAND()**in an empty cell, press the “**Enter**” key to execute the formula, and return the generated result.

Or

- Alternatively, type
**=R**or**=RA,**select the**RAND function**from the suggestions given by Excel, close the brackets [without entering any values or cell references], press the**“Enter”**key to execute the formula, and return the generated result.

### Download Template

This article must help understand **RAND Excel function **with its formulas and examples. You can download the template here to use it instantly.

### Examples

We will consider some advanced scenarios using the **RAND Excel function** examples.

#### Example #1

Let us consider the **RAND() function** to calculate the random numbers between 0 and 1. Then, the **RAND Excel function** returns the random numbers between 0 and 1, as shown in the table below.

#### Example #2

As you know, the **RAND formula in Excel** generates random numbers between 0 and 1. However, we can also return random numbers between 0 and 100, or any given range.

Ex. In the formula **=100*RAND(),**

- The
**RAND(),**by default, generates random numbers Excel between 0 and 1. - Then, the output is multiplied by 100 to get the digits between 0 and 100.

Finally, it will generate the random number in Excel, as shown below.

#### Example #3

If you want to calculate the random number in Excel between two numbers, then we can use the **RAND formula =a+ (b-a)*RAND(),** where a and b may be any numbers.

The **RAND formula** generates the random number between two integers.

Therefore, the formula for the Random number formula in excelRandom Number Formula In ExcelWe use random numbers in Excel when we wish to generate absolutely random random numbers to randomize our data for a sample evaluation, . In Excel, there are two built-in functions that offer us random numbers in cells: the =RAND() function provides us any value from 0 to 1, and the =RANDBETWEEN() function takes user input for a random number range.read more between 5 and 10 using will be,

**=5 + (10 – 5) * RAND().**

#### Example #4

As considered in the **Example 3**, to generate the random numbers between 5 and 10, we used the **RAND()** **formula** **=5 + (10 – 5) * RAND(), **and generated random numbers between 5 and 10. Now, apply the **INT()** function to round the output integer to the output’s nearest positive integer, as shown.

#### Example #5

The **RAND function** also generates random time. So, let us apply **RAND(),** and then change the cell format to time.

#### Excel RAND Function As A VBA Function

To use the **RAND Excel function **as a** VBA Function, **we enter the following** VBA Code **in the **VBAEditor **module window.

Dim RandomNumber As Integer

RandomNumber = Int ((100 – 50 + 1) * Rnd + 50)

End Sub

In this example, the variable called RandomNumber would now contain a random number between 50 and 100.

### Important **T**hings To Note

- The
**RAND()**function calculates a new value each time the worksheet is calculated. To overcome this problem,- We must convert the generated value to direct cell values.
- We can copy the generated numbers and paste it in any other cells. Then the numbers will remain as constant.

- Also, to stop the auto change of the
**RAND()**value, we must go to the go-to RAND formula Excel bar, and press**F9**to convert the**RAND formula in Excel**into its result. - We will get the
**“#NAME?”**error, if we enter any cell values or cell references within the**RAND()**formula’s brackets. The function itself is a formula.

### Frequently Asked Questions (FAQs)

**1. Where is RAND Excel function found?**

The **RAND Excel function **is found in the** “Formulas” **tab as follows:

First, choose an empty cell → select the “**Formulas**” tab → go to the “**Function Library**” group → click the “**Maths & Trig**” drop-down → select the “**RAND**” function, as shown below.

**2. What is the purpose of RAND function in Excel?**

The **RAND function** helps users generate random numbers in-between any 2 integer values.

**3. Why is the RAND function in Excel not working?**

The **RAND function **may not work for the following reasons,**• **A cell reference is entered as the argument.**• **Open and close brackets are missing, i.e., the function is entered as **=RAND** instead of **=RAND().**

### Recommended Articles

This article is a guide to RAND Function in Excel. Here we generate one or a range of random numbers between 0 to 1, examples and downloadable excel templates. You may also look at these useful functions in Excel: –

- Random Numbers in VBARandom Numbers In VBATo generate random numbers in vba we have an inbuilt function called RND. It just takes two numbers as input to generate random between these numbers. It creates random numbers which are greater than 0 and smaller than 1.read more
- Rand FormulaRand FormulaThe RAND function in Excel, also known as the random function, generates a random value greater than 0 but less than 1, with an even distribution among those numbers when used on multiple cells. read more
- Randomize List in Excel sheetRandomize List In Excel SheetRandomizing a list in excel means selecting a random value from the data, to randomize a whole list in excel. There are two excel formulae for this: the =RAND() function, which returns any random value to the cell and then allows us to sort the list, and the =RANDBETWEEN() function, which returns random values to the cell from a number range specified by the user.read more
- RIGHT Function in Excel
- VLOOKUP WildcardVLOOKUP WildcardWildcard Characters are used with the VLOOKUP function to avail the lookup value by only using the partial match. It helps make VLOOKUP more powerful & avoids the #N/A Error. read more