How to generate random numbers in excel

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

Recommended tutorial:

excel tutorial

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!