RANDARRAY function

The RANDARRAY function generates an array of random numbers between 0 and 1. The size of the array is determined by the provided rows and columns arguments.

Parts of a RANDARRAY function

RANDARRAY(rows, columns)

Part Description
rows The number of rows to return [optional]. Must be specified if columns is specified.
columns The number of columns to return [optional].

Sample formulas

Example 1 RANDARRAY()

Example 2 RANDARRAY(4, 2)

Notes

  • If rows and columns are omitted, RANDARRAY returns a 1x1 sized grid.
  • Like the RAND function, pressing enter will cause RANDARRAY’s results to update.

Examples

  A B
1 Formula Result
2 =RANDARRAY() 0.292929292
3    
4    

 

  A B C
1 Formula Result  
2 =RANDARRAY(4,2) 0.35464566 0.124214214
3   0.45674863412 0.4561312
4   0.4565146 0.12645601
5   0.7878945 0.13459698

Related functions

  • RAND Returns a random number between 0 inclusive and 1 exclusive.
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
6746348622321756622
true
Search Help Centre
true
true
true
true
true
35
false
false