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?
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 :
- 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.
