Current location - Education and Training Encyclopedia - Education and training - How to use the random function of Excel? How to use random functions
How to use the random function of Excel? How to use random functions
One of the main contents of Excel tables is function, and various function formulas help us to deal with copied data. Take random function as an example, everyone is unfamiliar with random function, that is, random function generator. Let's demonstrate the usage of random function in the following content. Come and study together. If you want to know more about the use of Excel functions, you can continue. There are free self-taught Excel basic video tutorials. Don't miss it.

How to use the random function of Excel;

Step 1: First, you need to open a new excel chart.

Step 2: As shown in the figure, the next operation is to put the cursor in the cell, enter "=rand ()", or insert the function formula rand. See the following requirements, input according to the following requirements, and return a uniformly distributed random number greater than or equal to 0 and less than 1, and return a numerical value every time the worksheet is calculated.

Step 3: As shown in the figure, then press enter.

Step 4: As shown in the figure, finally copy the filling formula to the lower right, and you will get a series of random numbers greater than or equal to 0 and less than 1. This concludes our demonstration of random functions.

This is the demonstration process of random function. It is as simple to operate as the max function.