## INTRODUCTION

*RANDARRAY FUNCTION is one of the very important and useful functions in GOOGLE SHEETS.* It is an array function which can return multiple values in one go.

*As RANDARRAY FUNCTION is concerned with the numbers , so it is present under the MATH FUNCTION CATEGORY of the functions.*

RANDARRAY FUNCTION HELPS US TO CREATE AN ARRAY OR GRID OF RANDOM NUMBERS. IT IS JUST LIKE THE RAND() FUNCTION, BUT WILL RETURN A COMPLETE GRID OF RANDOM NUMBERS AT ONCE.

*It finds out the exact same copy of the characters or text to be searched. It compares content as well as case of the text.*

*RANDARRAY FUNCTION is very useful in generating random numbers which are useful in the applications or formulas consisiting of NUMBER OF CHANCES or probability.*

*In this article we would learn about the purpose, syntax, formula of the RANDARRAY FUNCTION and get a better understanding with the help of the examples in GOOGLE SHEETS .*

## PURPOSE OF RANDARRAY FUNCTION IN GOOGLE SHEETS

**RANDARRAY FUNCTION GENERATES A GRID OF RANDOM NUMBER WITH THE CUSTOM NUMBER OF ROWS AND COLUMNS.**

For example,

if we are creating a game of random numbers which are needed in a grid i.e. with rows and columns just like a matrix, we can make use of randarray function easily.

Similarly we can create numbers random numbers with specified number of significant digits using the randarray function.

## PREREQUISITES TO LEARN RANDARRAY FUNCTION

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in GOOGLE SHEETS .
- Some information about the RANDOM NUMBERS
- Of course, availability of internet and google sheets login.

## SYNTAX: randarray FUNCTION

**The Syntax for the RANDARRAY function is=RANDARRAY **( NUMBER OF ROWS, NUMBER OF COLUMNS )

**NUMBER OF ROWS **is the number of rows of the grid of the random numbers which we want to create.

**NUMBER OF COLUMNS **is the number of rows of the grid of the random numbers we want to create.

Suppose we want to create a grid of 4×4 i.e. 4 rows and 4 columns random numbers, we can do it using the function =RANDARRAY (4,4)

## EXAMPLES: RANDARRAY FUNCTION IN GOOGLE SHEETS

### EXAMPLE TYPE 1: CREATE A GRID OF 20 RANDOM NUMBERS IN 4X5 GRID. [ 4 ROWS AND 5 COLUMNS ]

This example demonstrates a simple usage of RANDARRAY FUNCTION in google sheets.

Follow the steps to create the random numbers as required.

**STEPS TO CREATE A GRID OF RANDOM NUMBERS IN GOOGLE SHEETS**

- Select the cell where we want the first random number to be.
- Enter the formula as =RANDARRAY(4,5)

- Press ENTER.
- The google sheets will display the random number as shown below.

### EXAMPLE TYPE 2: create a grid of 60 [5×12] random numbers between 0 and 50.

We already learnt to create a grid of the RANDOM NUMBERS using the RANDARRAY FUNCTION but this time we need to put a limit on the numbers.

Previously we already saw that the random numbers were generated within 0 and 1 .

We need to create the numbers upto 50.

The second issue is to create a whole number. We already saw that the random numbers generated have a number of decimal digits.

So keeping these facts in mind, follow the steps to create the pattern as desired.

**STEPS TO CREATE A GRID OF 60 NUMBERS BETWEEN 0 AND 50:**

- Select the cell where we want the first number to show.
- Enter the formula as
**=ARRAYFORMULA(INT(RANDARRAY(5,12)*50))** - Press ENTER.
- The result will appear as shown in the picture below.
- The EXPLANATION of the formula follow the picture.

**EXPLANATION:**

Let us understand the working of the formula.

We used the formula **=ARRAYFORMULA(INT(RANDARRAY(5,12)*50))**

The first function used is the ARRAYFORMULA which lets us make the NON ARRAY FORMULAS AS ARRAY FORMULAS. In our expression INT function is a non array formula.

The INT function returns a whole number less than or equal to the NUMBER passed into INT. For example =INT(15.12) will return 15 , =INT(89.98) will return 89 and so on.

RANDARRAY as we already discussed in previous example, will create the grid of 60 elements between 0 and 1 so we multiplied it with 50 which will return us the numbers between 0 and 50.

Hence we achieve the result.