Current location - Recipe Complete Network - Complete cookbook - How to generate random numbers in a certain range in excel
How to generate random numbers in a certain range in excel
1. First, enter the random function formula in the cell of the excel table: =RAND ().

2. Click Enter to generate a random number. The size range of data cannot be controlled and needs to be set within a certain range.

3. For example, if it needs to be set between the number 5 and the number 15, you can enter a random function: =RAND()*( 15-5)+5.

4. Click [Enter] to generate the calculation result according to the entered formula. As can be seen in the figure below, the generated random data is between 5 and 15.