How to use random function rand in excel

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!