The size or the array is determined byrowsandcolumnsarguments.
By default, RANDARRAY returns an array of random numbers between 0 and 1.
However, RANDARRAY will generate whole numbers when theintegerargument is set to TRUE.
When RANDARRAY returns multiple results in a worksheet, results willspillinto adjacent cells.
By default,rows,columns, andmaxdefault to 1, whilemindefaults to zero andintegerdefaults to FALSE.
For example, =RAND() will generate a number like 0.422245717.
RAND recalculates when a worksheet is opened or changed.
RANDBETWEEN Function
The Excel RANDBETWEEN function returns a random integer between two given numbers.
RANDBETWEEN recalculates each time a worksheet is opened or changed.
