How to use Excel RANDARRAY Function in Excel Worksheet?
Tags: touseexcelrandarrayf, excel, excelfunctions
Published: 2021-08-26 02:09:06

---
title: How to use Excel RANDARRAY Function in Excel Worksheet?
published: true
date: 2021-08-23 15:59:12 UTC
tags: ToUseExcelRANDARRAYF,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-randarray-function-in-excel-worksheet/
---

Have you ever tried to use these functions In your Excel Spreadsheet? In this tutorial, we will guide you on **how to use the Excel RANDARRAY Function In Excel Worksheet**. Let’s get them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## RANDARRAY function

The **RANDARRAY function** returns an **array of random numbers**. You can specify the **number of rows and columns to fill** , **minimum and maximum values** , and whether to **return whole numbers or decimal values**.

## RANDARRAY function Syntax

```
=RANDARRAY([rows],[columns],[min],[max],[integer])
```

**Syntax Explanation:**

- [rows]: The number of numbers that you want vertically (number of rows you want fill).
- [columns]: The number of numbers that you want horizontally (number of columns you want fill).
- [min]: The starting number or the minimum value of the random number/s.
- [max]: The maximum range of the number.
- [integer]: Set it true, if you want the random numbers to be whole numbers. By default, it is false and returns fractional random numbers.

## Use RANDARRAY Function

- Firstly, if you just want a **random fractional number** between **1 and 0,** you have to write this **formula** :

```
=RANDARRAY()
```

- Then, if you want an **array of 10 fractional numbers** spilled downwards, you need to write this **formula** :

```
=RANDARRAY(10)
```

- Now, after hitting the **enter** button, **10 rows** below will be filled with **10 random fraction numbers** , because it is a **dynamic array function**.
- After that, if you want an **array of 20 fractional numbers** spilled in **10 rows downwards and 2 columns** to the right, you have to write this **formula** :

```
=RANDARRAY(10,2)
```

- Then, if you want an **array of 20 fractional numbers**  **between 40 and 60** , spilled in **10 rows downwards** and **2 columns to the right** , you need to write this **formula** :

```
=RANDARRAY(10,2,40,60)
```

- Now, if you want an **array of 20 whole numbers** spilled in **10 rows downwards and 2 columns to the right** , you have to write this **formula** :

```
=RANDARRAY(10,2,40,60,1)
```

**Check this too:** [Excel Formulas to Define Range Based on Cell Value ~ Quickly!!](https://geekexcel.com/excel-formulas-to-define-range-based-on-cell-value/)

## Wrap-Up

From this chapter, you can get some clarification about **how to use the Excel RANDARRAY Function In Excel Worksheet**. Let me know if you have any **doubts** regarding this article or any other Excel/VBA topic.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Related Articles:**

- **[How to Create an Array of Numbers in Excel Office 365?](https://geekexcel.com/how-to-create-an-array-of-numbers-in-excel-office-365/)**
- **[Excel Formulas to Convert the String into Array ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-convert-the-string-into-array/)**
- **[Formulas to Generate Random Date between Two Dates!!](https://geekexcel.com/excel-formulas-to-generate-random-date-between-two-dates/)**
- **[Excel Formulas to Generate Random Text Values ~ Useful Tricks!!](https://geekexcel.com/excel-formulas-to-generate-random-text-values-useful-tricks/)**
- **[Excel Formulas to Generate Random Value from List or Table ~ Quickly!!](https://geekexcel.com/excel-formulas-to-generate-random-value-from-list-or-table/)**