## What is RANDARRAY Function in Excel?

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

It Returns an **array of random** numbers.

These names only apply within the scope of the **RANDARRAY** function.

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

## How to use RANDARRAY 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 **RANDARRAY** function

6. Then select **ok**.

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

8. ROWS section is the number of **random **numbers.

9. COLUMNS section is the number of **columns **in the returned array.

10. MIN section is the **minimum number** you would like returned.

11. MAX section is the **maximum number** you would like returned.

12. INTEGER section is return an **integer **or a **decimal **value. TRUE for an integer and False for a decimal number.

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

## Examples of **RANDARRAY** function in Excel

**Example 1:**

**How to use RANDARRAY function in excel**

You can see examples of RANDARRAY function below:

**randarray**(A2,B2,C2,D2,E2) ----->>>>answer is 0.617

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

**RANDARRAY**

It Returns an **array of random** numbers.

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

**RANDARRAY**

It returns a number.

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

**RANDARRAY**

This function has just **5** Argument.

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

ROWS section is the number of **random **numbers.

COLUMNS section is the number of **columns **in the returned array.

MIN section is the **minimum number** you would like returned.

MAX section is the **maximum number** you would like returned.

INTEGER section is return an **integer **or a **decimal **value. TRUE for an integer and False for a decimal number.

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

```
RANDARRAY(number) = number
```

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

**RANDARRAY**

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

## Errors in **RANDARRAY** function

**RANDARRAY**

## RANDARRAY** related functions :**

- SORT function
- Use SEQUENCE function to return a SEQUENCE of numbers.
- Use RAND function to return a random number greater than or equal to 0 and less than 1.
- Use RANDBETWEEN function to return a random number between the numbers.