Do you know the excel random number function?

php editor Baicao will introduce to you the random number function in excel today. The random number function is widely used in Excel, which can help users quickly generate random data and improve work efficiency. By learning the usage of the random number function, we can better apply the functions of excel and complete more different types of tasks. Let’s find out together!

1. Generate random numbers from 0 to 50, and use the =rand()*50 formula to calculate, as shown in the figure below.

2. To generate random integers from 0 to 50, use the =round(rand()*50,0) function, and nest a rounding function before the rand() function. , and retain one significant figure.

3. To generate a random number between 15-70 and a random number between a-b, you can use the function formula =rand()*(b-a) a, so Use the formula =rand()*(70-15) 15 to calculate.

4. Generate an integer between 15-70. Similarly, nest the formula =round(rand()*(70-15) 15, in front of the random number. 0) Just calculate.

5. How to generate random numbers between 5 and 100 that are multiples of 5? Use the formula =ROUND((RAND()*(100-5) 5)/5,0)*5 to generate.

Or use the formula =CEILING((RAND()*(100-5) 5),5) formula as shown below.

6. Generate random numbers between 1 and 5, but appear with a probability of 5%, 10%, 15%, 30%, and 40%. Use the formula =MATCH(RAND(),{0,0.05,0.15,0.3,0.6}) formula for calculation.

7. Generate 10 non-repeating random numbers from 0 to 9, place them in 10 cells, and enter the function =rand() in cells A1-A10. function, then enter the formula =rank(a1,a:a)-1 in cell B1 and fill in the formula downwards.

I believe that after reading this article, everyone has a detailed understanding of the rand function. The first few operations are considered to be the basic uses of this function, and the following few operations are considered to be the function. Advanced usage skills. The wonderful thing about Excel is that it is very learnable. Many things that seem to have no clue can actually be solved as long as you master the skills and rules and methods of using functions. I hope friends in need can practice more.

The above is the detailed content of Do you know the excel random number function?. For more information, please follow other related articles on the PHP Chinese website!