If you want to generate random. RAND function returns a random number ranging from 0 to 1. The RANDARRAY function returns an array of random numbers.
Excel RAND function - generate random real numbers The RAND function in Excel is one of the two functions specially designed for generating random numbers.
In the following examples we created an array thats 5 rows tall by 3 columns wide. Type the function RAND into the formula bar above the worksheet. The RAND function can be used to simulate a random process. RAND The RAND function syntax has no arguments.