• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

http://spreadsheets.about.com/od/excelfunctions/qt/080218_rand.htm

was emailed to:

Thanks for sharing About.com with others!

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

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.
##### Excel Trig Functions

Ted French
About.com Spreadsheets

See More About
Explore Spreadsheets
See More About:
By Category
1. About.com
2. Technology
3. Spreadsheets
4. Excel Functions
5. Random Number Functions
6. Generate Random Numbers in Excel