How to use the random function rand in excel: first enter the formula [=INT(100*RAND()) 1] in cell B1; then press Enter to get a random number; finally pull down the cell , you will get a group of cells within 100.
How to use the random function rand in excel:
1. The random function rand can return greater than or equal to 0 And a uniformly distributed random number less than 1.
The following uses the example of finding a random integer within 100 to explain the usage of the function.
2. Enter the formula =INT(100*RAND()) 1
3 in cell B1 and get a random number
4. Pull down the cell to get a group of cells within 100.
5,INT(100*RAND()) 1Explanation:
100*RAND() means 0-100 Any random number within (excluding 100).
The int function is a downward integer function. After adding 1, you can randomly get a random integer greater than or equal to 1 and less than or equal to 100.
Related learning recommendations:excel tutorial
The above is the detailed content of How to use random function rand in excel. For more information, please follow other related articles on the PHP Chinese website!