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.

Can randomly generate any random integer within this range.

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!