**These are the example of random function in excel :**

Make two columns in excel fill some values in column A1, A2, A3 and Just copy this function =RAND()*(A2-A1)+A1 to cell C3 you would get the random number see given functions below and execute them one by one accordingly.

=RAND()*(A2-A1)+A1
Result: random number (between 50 and 149.9999999)
=RAND()*(A3-A1)+A1
Result: random number (between 50 and 199.9999999)
=RAND()*(200-100)+100
Result: random number (between 100 and 199.9999999)
=INT(RAND()*(200-100)+100)
Result: random number (between 100 and 199, integer value)

Thanks!