RANDARRAY (PQL - xl)

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

  • Library: PQL \ Spreadsheet \ Math & Trig
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

RANDARRAY(rows, columns, min, max, OPTIONAL integer)

Function Arguments

Name

Description

Type

Optional

rows

Specifies the number of rows of random numbers to generate (if nothing is specified, the default value 1 is used)

Number

columns

Specifies the number of columns of random numbers to generate (if nothing is specified, the default value 1 is used)

Number

min

Specifies the minimum of values to generate (if nothing is specified, the default value 0 is used)

Number

max

Specifies the maximum of values to generate (if nothing is specified, the default value 1 is used)

Number

integer

Returns an integer only if the specified value is Boolean TRUE. If this value is FALSE, this function returns a decimal value (if nothing is specified, the default value FALSE is used)

StringOrNumber

Y

Comments

This function is the same as the Microsoft Excel 'RANDARRAY' function - using the same inputs, logic and outputs.