# HOW TO USE RANDARRAY FUNCTION IN EXCEL ?

## INTRODUCTION

RANDARRAY FUNCTION is one of the very important and useful functions in EXCEL. 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.

RANDARRAY FUNCTION is very useful in generating random numbers which are useful in the applications or formulas consisting 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 Microsoft Excel .

## PURPOSE OF RANDARRAY FUNCTION IN EXCEL

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 EXCEL .
• Some information about the RANDOM NUMBERS
•  Of course, EXCEL APPLICATION.
• LEARN BASICS OF EXCEL HERE.

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

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

Follow the steps to create the random numbers as required.

#### STEPS TO CREATE A GRID OF RANDOM NUMBERS IN EXCEL

• Select the cell where we want the first random number to be.
• Enter the formula as =RANDARRAY(4,5)
• Press ENTER.
• The EXCEL 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 up to 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 =(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.