For example, =RAND() will generate a number like 0.422245717.
The RAND function takes noarguments.
RAND recalculates when a worksheet is opened or changed.
RANDBETWEEN recalculates each time a worksheet is opened or changed.
RANDARRAY Function
The Excel RANDARRAY function generates an array of random numbers between two values.
The size or the array is specified byrowsandcolumnsarguments.
The generated values can be either decimals or whole numbers.
