The
Excel RAND function will generate a random number in Excel that is greater than or equal to 0 and less than 1.
The syntax for the
RAND function is:
=RAND( )
To use the RAND( ) function (examples)
To generate a random number between 0 and 100, use =RAND() *100
To generate a random number and return only whole numbers use =INT(RAND()*100)
To generate a random number between 100 and 200, use =RAND() *(200-100)+100
Note: If you want to use RAND function to generate a random number but don't want the numbers to change every time the cell is calculated, you can enter =RAND() in the formula bar, and then press F9 key to change the formula to a random number.
|
01-26-2010, 09:46 AM
Topic 26: Using Excel RAND() Function to Generate Random Numbers
