In this lesson you can learn how to use RAND function in Excel

RAND function draws a value between 0 and 1.



Since the operation is done from scratch each time per sheet, it is best to immediately convert it into value. Otherwise it draws a new value each time you change the data in the file. Often the result of this function is multiplied by or divided to obtain an order of magnitude of numbers that we are interested in

  • =RAND()*1000 
  • =0.5+RAND()/10
  • =RAND()*(100-50)+50
  • =RAND()*(A1-A2)+A2
  • =INT(RAND()*(A1-A2)+A2)

The function is sometimes used most often to create a variety of data, which look realistic. Most of the data in Best Excel Tutorial was created using this function.