RANDARRAY Function Explained

The RANDARRAY Function in Microsoft Excel generates an array of random numbers between two specified numbers. It takes two arguments: min and max, which are the lower and upper bounds of the range of random numbers to be generated. The function returns an array of random numbers between the two specified numbers.

RANDARRAY Function Syntax

RANDARRAY(rows, columns, min, max)

  • rows: The number of rows in the array.
  • columns: The number of columns in the array.
  • min: The minimum value of the random numbers.
  • max: The maximum value of the random numbers.