# RAND Excel Function

Published on :

21 Aug, 2024

Blog Author :

N/A

Edited by :

Sheeba M

Reviewed by :

Dheeraj Vaidya

## 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.

##### Table of contents

- 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 , 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 excel 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 VBA
- Rand Formula
- Randomize List in Excel sheet
- RIGHT Function in Excel
- VLOOKUP Wildcard