How to get random numbers from range in excel

How to get random numbers: First open the excel table that needs to be operated, select the specified cell; then enter the formula "=RANDBETWEEN (lower limit value, upper limit value)" in the input box to randomly generate this Any random value within the range.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Open excel and enter =RANDBETWEEN function in the selected input box

Specify an upper limit and a lower limit. For example, this time the lower limit is 1 and the upper limit is is 10.

Related learning recommendations:excel tutorial

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