RANDARRAY

This function returns an array of random numeric values. Users can specify the number of rows and columns, and minimum and maximum values, and indicate whether to return integers or decimal values.

Syntax

RANDARRAY([rows],[columns],[min],[max],[integer])

Arguments

RANDARRAY function has the following arguments:

Data Types

Accepts the number of rows and columns. Returns an array of random numbers.

Note: RANDARRAY is a volatile function. This means that each time the worksheet calculates, the RANDARRAY function recalculates the new values.

Remarks

By default, if users don't specify the row or column argument, the RANDARRAY function will return a single value between 0 and 1. Also, if minimum and maximum arguments are not specified, then the RANDARRAY function returns a random set of values between 0 and 1. The minimum number argument should always contain a value that is less than the maximum number, else this function will return a #VALUE! error. Further, if the whole-number argument is empty, then this function will choose FALSE as the default value and the decimal value will be returned.

Examples

For instance - Cell A8 in the following image contains the formula "=RANDARRAY(5,3)" and returns a random set of values between 0 and 1.

RANDARRAY(5,3,1,100) returns a series of random decimal values between 1 and 100.

RANDARRAY(5,3,1,100,TRUE) returns a series of random whole numbers between 1 and 100.

Version Available

This function is available in SpreadJS 13 or later.