==RANDARRAY([rows],[columns],[min],[max],[whole_number])
=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.
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.