How to generate random decimals in excel

The method for excel to generate random decimals is: it can be achieved through the RAND() function.

The specific method is as follows:

For example, we now want to generate random decimals from 1 to 100.

First select cell A1, then enter the formula [=RAND()*(100 - 1) 1] into cell A1 and press Enter. In this way we successfully generated a random number between 1 and 100.

Use the same method to drag down and save, and other random numbers will be generated, as shown below:

Recommended tutorial:excel tutorial

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