Learn How to Use Microsoft Excel RANDARRAY Function
In this article, you will learn how to use the Microsoft Excel RANDARRAY function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel RANDARRAY function return value and syntax with the help of some examples.
Microsoft Excel RANDARRAY Function
The primary function of the Microsoft Excel RANDARRAY function is to get an array of random numbers. That means with the help of RANDARRAY, you can generate a variety of random numbers in between. The array can be specified by the rows and column arguments, and the values generated can either be decimals or whole numbers.
Return Value of RANDARRAY Function
The return value array of random numbers
Syntax of RANDARRAY Function
=RANDARRAY([rows], [columns], [min], [max], [integer])
Where the arguments:
rows: The number of rows to return, default is 1 (optional).
columns: This is the number of columns to return, default is 1 (optional).
min: This is the minimum value to return, default is 0 (optional).
max: This is the maximum value to return, default is 1, (optional).
integer: This returns the whole numbers, Boolean TRUE or FALSE, default is FALSE (optional).
How to Use Microsoft Excel RANDARRAY Function?
The Microsoft Excel RANDARRAY function is a dynamic array function. The function returns the array of random numbers between 0 and 1. You can determine the size of the array with the help of supplied rows and columns arguments. The value generated by the RANDARRAY function can either be a whole number or decimal value. In case the RANDARRAY returns multiple results, it will spill up in an adjacent cell.
Check out the list of all other articles:
- Learn How to Get nth Match in Microsoft Excel
- Learn How to Find Missing Values in Microsoft Excel
- Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
- Learn How to Sort by Text Length in Microsoft Excel
- Learn How to Sort by Two Columns in Microsoft Excel
- Learn How to Sort by Random in Microsoft Excel
- Learn How to Sort by One Column in Microsoft Excel
- Learn How to Sort by Custom List in Microsoft Excel