To generate random numbers, you can use the RAND() function.
1. Enter the formula in the cell where you need to generate a random number: =RAND( )
2. Press Enter to generate a random number between 0 and 1
If we need random numbers in other ranges, we can use the RAND() function as the base number.
3. For example, if we need to generate a random number between 30 and 60, we need to enter the formula =30 RAND( )*(60-30)## in the cell.
#4. Press the Enter key to generate a random number between 30 and 60
The above is the detailed content of How to generate random numbers in excel. For more information, please follow other related articles on the PHP Chinese website!