Google Sheets Formulas

others

RANDARRAY Function in Google Sheets: Explained

SHARE THIS Article

In this article, you will learn how to use the RANDARRAY formula in Google Sheets.

What is the RANDARRAY function in Google Sheets?

The RANDARRAY function in Google Sheets is a function that generates a random array of numbers between 0 and 1, which you can use to populate a range of cells in a spreadsheet with random values.

   Save hours formatting your next financial spreadsheet!

   100+ templates, all free to use.

   Free Spreadsheet Templates

How do I use the RANDARRAY function in Google Sheets?

Here is the syntax for the RANDARRAY function:

=RANDARRAY([rows], [columns])

rows: The number of rows in the array.

columns: The number of columns in the array.

Note that the two parameters are optional, so you can leave them blank. In that case, the formula shows a 1x1-sized array, a single random value.

For example, if you wanted to generate a 2x2 array of random values between 0 and 1, you could use the following formula:

=RANDARRAY(2, 2)

This would generate a 2x2 array of random values between 0 and 1, like this:

Generate the 2x2-sized array showing random numbers

   Turn Quickbooks Online data into a Google Sheets dashboard

    100+ templates, update automatically, totally secure!

   Book a Demo

Supercharge your financial reporting