1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Random Numbers in Excel

Generate Random Numbers with the RAND Function

By

Generate Random Numbers in Excel

Generate Random Numbers in Excel

© Ted French

One way to generate random numbers in Excel is to use the RAND function. This function produces a random number between 0 and 1.

The syntax for the RAND function is:

= RAND ( )

Note: This function takes no arguments.

Example: Using Excel's RAND Function

  1. Click on cell E1 in the spreadsheet - the location where the results will be displayed.

  2. Click on the Formulas tab of the ribbon menu.

  3. Choose Math & Trig from the ribbon to open the function drop down list.

  4. Click on RAND in the list to bring up the function's dialog box.

  5. Click OK.

  6. A random number between 0 and 1 should appear in cell E1.

  7. To generate another random number, press the F9 key on the keyboard.

  8. When you click on cell E1 the complete function = RAND ( ) appears in the formula bar above the worksheet.

©2014 About.com. All rights reserved.