## What is RAND Function in Excel?

The** RAND** function is one of the math functions of Excel.

It Returns **a random number greater than or equal to 0 and less than 1**, evenly distributed (changes on recalculation).

We can find this function in **Math & trig** category of insert function Tab.

## How to use RAND function in excel

- Click on an
**empty cell**(like F5 )

2. Click on **fx icon** (or press** shift+F3**)

3. In the** insert function tab** you will see all functions

4. Select **math and trig** category

5. Select **RAND** function

6. Then select **ok**

7. In the function arguments Tab you will see** RAND** function

8. The Rand function has **no arguments**

9. You will see **results **in the formula result section

## Examples of **RAND** function in Excel

**Example 1:**

**How to use RAND function in excel**

You can see examples of RAND function below:

**rand**(A2) ----->>>>answer is 0.840
**rand**(A3) ----->>>>answer is 0.297
**rand**(A4) ----->>>>answer is 0.078
**rand**(A5) ----->>>>answer is 0.351
**rand**(A6) ----->>>>answer is 0.147

## What is the purpose of **RAND** function?

**RAND**

It Returns **a random number greater than or equal to 0 and less than 1**, evenly distributed (changes on recalculation).

## What is the Return value of **RAND** function?

**RAND**

It returns a number.

## How many arguments does **RAND** function have?

**RAND**

This function has **no arguments**.

The **argument **of RAND function is **number**.

The argument of RAND function is **required **and not optional.

```
RAND(number) = number
```

## Which version of excel supports **RAND** function?

**RAND**

This function is available for all excel **versions **(2003-2019)

## Errors in **RAND** function

**RAND**