Generate Random Numbers in Excel

by Sanju 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.

Tagged in:

764
like
0
dislike
0
mail
flag

You must LOGIN to add comments