Formulas > =RANDARRAY()

How To Use RANDARRAY() Function in Google Sheets


Generates an array of random numbers between 0 and 1.

Common questions about the RANDARRAY formula include:

1. What is the RANDARRAY formula used for?
2. How do I enter the RANDARRAY formula?
3. How do I properly format the RANDARRAY formula?

The RANDARRAY formula can be used to quickly generate random numbers in a range. It takes 2 or 3 inputs and returns an array of random numbers between the inputted range.

Common ways the RANDARRAY formula is mistyped include using the wrong order of arguments, misunderstanding the syntax, or inadvertently adding extra parameters. Can be mistyped as RNDARRAY, or RANDARRY, or RDARRAY, or RANDRAY.

Common ways the RANDARRAY formula is used inappropriately include using inconsistent parameters or parameter values, using non-numeric values in the formula, and trying to generate random numbers from non-numerical data.

Common pitfalls when using the RANDARRAY formula include using parameters that are too wide (resulting in extremely large arrays), or not understanding that RANDARRAY will generate a different set of numbers every time.

Common mistakes when using the RANDARRAY Formula include not understanding the maximum and minimum values in the syntax, specifying an incorrect dimension of the array, or typing the formula incorrectly.

Common misconceptions people might have with the RANDARRAY Formula include that the RANDARRAY formula will always output the same set of numbers, or that the RANDARRAY formula will generate a set of unique numbers.

How To Actually Use RANDARRAY() in Sheets

RANDARRAY(rows, columns)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the RANDARRAY() formula:

RANDARRAY function in Excel | excel new formulas 2020

This video shows you RANDARRAY New formula | How to get random decimal & integer value using function in MS Excel Office . This is a dynamic array formula. This is one of the new AI feature in excel.

Generate a RANDARRAY() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.