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 1 x 1 sized grid.
  • Like the RAND function, hitting 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
5717980220678557431
true
Search Help Center
true
true
true
true
true
35