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.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

    Can't find what you're looking for? Try Google Search!

    Google
     

    Back to Top


    >> Next Topic : Discover the Excel Automatic Calculation Capability!

    << Previous Topic : Use the Excel OR( ) Function Correctly


    You're viewing the Excel RAND Function info page, click here to go back to the Home Page