Saturday, January 14, 2012

How to Generate 20 Random Numbers in Excel 2007


1. Open the Excel 2007 file where you want to create 20 random numbers.
2. Click an empty cell that has another 19 empty cells directly beneath it.
3. Type '=rand()*(y-x) x' into the formula bar. Replace 'x' and 'y' with the range of numbers that the random number will fall between. For example, '=rand() (10-1) 1' will return a random number between 1 and 10. Press 'Enter.'
4. Click the cell with your formula in it, which now displays a random number. Move your mouse over the bottom-right corner of the cell, where the pointer turns into a plus sign. Click the mouse button and hold it down. Move the mouse down 19 cells beneath the first and release the mouse button. You now have 20 random numbers, although each number is written out to nine decimal places.
5. Click and hold the mouse button on the first random number cell, and then drag the mouse to the last cell and release the button. Right-click anywhere in the selected range and click 'Format Cells' from the menu.
6. Click 'Number' from the list on the left side of the window. On the right side, change the field after 'Decimal places' to be equal to the number of decimal places you want to display on the Excel sheet. Click 'OK' to continue.

Blogger news