RANDARRAY

Formulas / RANDARRAY
Generate an array of random numbers.
=RANDARRAY([rows],[columns],[min],[max],[whole_number])
  • Rows - [OPTIONAL] the row count
  • Columns - [OPTIONAL] the column count
  • Min - [OPTIONAL] the minimum value
  • Max - [OPTIONAL] the maximum value
  • Integer - [OPTIONAL] Boolean, TRUE or FALSE

Examples

  • =RANDARRAY(10,1)

    This example uses the RANDARRAY function to generate a single random number between 0 and 1. The function will return a single random number in the specified range each time it is used.

  • =RANDARRAY(1,10)

    This example uses the RANDARRAY function to generate a single random number between 1 and 10. The function will return a single random number in the specified range each time it is used.

  • =RANDARRAY(3,1,1,5)

    This example uses the RANDARRAY function to generate three random decimal values in columns between 1 and 5. The function will return three random decimal values in the specified range each time it is used.

Summary

The RANDARRAY function is used to generate a random array of numbers with a specified size. The values generated are either decimals or whole numbers and are determined by the min and max arguments supplied. The function is volatile, so it may cause performance issues in large or complex worksheets.

  • The RANDARRAY function generates a random array of numbers, specified by the number of rows and columns.
  • By default, RANDARRAY returns an array of random numbers between 0 and 1.
  • When the integer argument is set to true, RANDARRAY returns whole numbers instead.

Frequently Asked Questions

What is the RANDARRAY function?
The RANDARRAY function is a volatile function in Sourcetable that creates an array of random numbers. The size of the array is determined by the rows and columns arguments, and the generated values can be decimals or whole numbers.
What are the arguments for the RANDARRAY function?
The arguments for the RANDARRAY function are rows, columns, min, max, and an integer.
Are there any performance issues with the RANDARRAY function?
Yes, the RANDARRAY function may cause performance issues in large or complex worksheets.
What are some tips for using the RANDARRAY function?
  • Be mindful of the size of the array you are generating.
  • If you are generating large or complex arrays, try to limit the size to improve performance.
  • Be aware that the RANDARRAY function is a volatile function, so it will recalculate every time the worksheet is recalculated.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.