How to randomly generate decimals within a range in excel

1. Select a cell range;

As shown in the figure below, generate a random number between 10-100 with two decimal places in this range.

#2. Use the Randbetween function in Excel to generate integers within a specified range. To generate decimals, just generate an integer first and then divide it by a multiple of 10. So enter the formula =randbetween in Excel, as shown in the figure below.

3. Set the upper and lower limits of random numbers;

Set the first parameter of the randbetween function, that is, the lower limit of random numbers to 1000, and the second parameter is The upper limit of random numbers is 9999, as shown in the figure below.

4. Divide the function result by the specified multiple of 10;

5. Press the Ctrl and Enter keys Fill in the formula to get random decimals.

Recommended tutorial: excel tutorial

The above is the detailed content of How to randomly generate decimals within a range in excel. For more information, please follow other related articles on the PHP Chinese website!