The use of Rand function in excel2010

Enter the RAND function formula in cell A2. The system then draws a random number.

If you do not want a number after the decimal point, you can take the integer portion of the cell by adding the INT function before the RAND function.

Enter the INT (RAND () * (300-200) +200) in cell B2 to allow the system to generate a value within the 200~300 interval.

Enter the INT (RAND () * (400-300) +300) in cell C2 to allow the system to generate a value within the 300~400 interval.