How to Generate Random Numbers in MS-Excel

If you want to generate random numbers for use in your Excel spreadsheet, the RAND function helps to generate numbers without any specifications. But what if you need to generate random numbers only within a given range?  Just follow these simple steps to learn how.

Generate random numbers in excel 2007

  • Click on the cell where you would like to begin entering random data.
  • Enter the function ‘=RANDBETWEEN (bottom,top)’ to generate random numbers within a certain range. Replace the value ‘bottom’ with the lowest number you want generated and ‘top’ with the highest number you want generated.

For example, enter ‘=RANDBETWEEN (1000, 1200)’ for generating random numbers between 1000 and 1200.

  • Select the cell where you have entered the function and left click on extreme right hand bottom on the cell where the ‘+’ sign appears, and drag it to fill the cells beneath and adjacent to it with random numbers in the selected range, as per your requirements.
Filed under: Tips n Tricks
Tags: , , , , , , ,
July 31, 2009 by: Prasanth Chandra

Leave a Reply