The Excel RAND function
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.
Can't find what you're looking for? Try Google Search!
Back to Top
You're viewing the Excel RAND Function info page, click here to go back to the Home Page
|
