Brothersoft.comWindows|Mac|Mobile|Games

|Message

Solve software problem quickly Share experience to help others Improve the ability of solving problem
How to Generate a Random Number in Excel

11/15/2011 07:22 by ScottHamman

First answer posted by tdintx at 11/15/2011 07:22
Add Your Answer
10~1000 characters in length CAPTCHA:
1 Answers
  • tdintx
    1. Open Microsoft Excel 2007, and start a new, blank spreadsheet or open an existing spreadsheet from your files into which you want to generate a random number.

    2. Click the cell you want to generate a random number into so it is selected. The cell will have a thick black line outlining it.

    3. Type "=RAND()" (no quotations) into the "Formula" text box near the top of the Excel screen. This is the function that instructs Excel to enter a random number between 0 and 1 into the selected cell.

    4. Press the "Enter" key on your keyboard. The random number will be generated into the selected cell and you will be taken to the cell beneath it.

    5. Continue the process of generating random numbers into your Excel cells using the same method as outlined above.

  • Was this answer helpful? 00 · 11/15/2011 07:22
Add Your Answer
10~1000 characters in length CAPTCHA:
Related Questions
Q:What are the Three Types of Keyword Settings Tools

A:You can use keyword settings tools to assist with Internet searches. According to Webopedia, a keyword is "an index entry that identifies a sp...(more)

Q:How to Refer to a Range Name in Excel

A: Start Microsoft Excel 2007 and open an existing workbook that contains range names that you would like to use in a formula. Click on the c...(more)

Q:How to Make Gridlines Print in Microsoft Excel 2007 Spreadsheets

A: Select the "Page Layout" tab. It is located on the "Ribbon," the group of icons above the work area in Excel. Put a check in the "Print" b...(more)

Q:How to Create a Report in Microsoft Excel 2007

A: Complete the data and calculations in your worksheet. Even if your data and calculations span multiple worksheets, you can pull the data tog...(more)

Q:How to Make a Word Search With 2007 Microsoft Excel

A: Change the page orientation to landscape. Click on "Page Layout," then "Orientation," then "Landscape." Add a header and footer. The heade...(more)

0 people are following

Ask a question now
Write a title for your question

Microsoft Excel Viewer 2003

open, view, and print Excel workbooks, even if you have example excel formula.
Latest version:1.0
License:Freeware
OS:Windows 2003,Windows XP,Windows 2000
Total downloads:445,228
Rank:1 in Spreadsheets
Download It

Share with friends

New features is coming

  • 1. Providing high-quality answers to be a verified Q&A expert
  • 2. Ask and answer questions to get Brothersoft credits

Added Successfully!

×

Are you sure to delete your answer?

NoYes

×

Are you sure to choose it as the best answer?

NoYes

×

Voted Successfully!

×

You can't vote for yourself

×

You can't choose your own answer

×