Arrow left
Back to guides
Google Sheets Formulas

RANDARRAY Function in Google Sheets: Explained

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:


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

How to generate the 2x2-sized array showing random numbers between 0 and 1 in Google Sheets

Turn Quickbooks Online data into a Google Sheets dashboard
100+ templates, update automatically, totally secure!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below