Excel RANDARRAY Function

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

  1. Click on an empty cell (like F5 ).
empty cell in excel

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

fx icon in excel

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

insert function tab in excel

4. Select math and trig category.

5. Select RANDARRAY function

6. Then select ok.

excel  RANDARRAY function

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

How to use RANDARRAY function in excel

Examples of RANDARRAY function in Excel

Example 1:

How to use RANDARRAY function in excel

You can see examples of RANDARRAY function below:

Examples of RANDARRAY function in Excel
randarray(A2,B2,C2,D2,E2) ----->>>>answer is  0.617

What is the purpose of RANDARRAY function?

It Returns an array of random numbers.

What is the Return value of RANDARRAY function?

It returns a number.

How many arguments does RANDARRAY function have?

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?

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

Errors in RANDARRAY function

RANDARRAY related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *