Generate Random Numbers in Excel
by Sanju[ Edit ] 2012-07-04 15:52:01
Generate Random Numbers in Excel
To generate a number between 0 and 1, type
=RAND() in a cell.
To generate a number between 1 and 100, type
=RAND()*100.
After entering, use the fill handle to quickly populate as many cells with random numbers as needed. To use the fill handle, click the cell, move your pointer over the lower-right corner of the cell until it turns into a black plus sign, and drag it horizontally or vertically across the cells you wish to populate. The cells can then be formatted as desired.
