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 a Range in Excel

11/15/2011 07:22 by SaideeDay

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

    2. Select the cell or multiple cells that you want to generate the random number into. You can use the SHIFT or CTRL keys on your keyboard to select multiple cells at the same time. The cells that random numbers will be generated into will be outlined by a black heavy line.

    3. Type "=RANDBETWEEN" (no quotes) into the "Formula" textbox near the top of the Excel screen.

    4. Continue to type the rest of the function that specifies the range you want the random numbers to fall into. "([Bottom],[Top])" (no quotes) should be inserted after "=RANDBETWEEN" (no quotes) with numbers replacing the word "Bottom" and "Top." The "Bottom" number should be the lowest random number you want to be generated ant the "Top" number should be the highest number you want to be generated.

    5. Press the "Enter" key on your keyboard if you selected one cell or the "CTRL+ENTER" if you have selected multiple cells. You will now see random numbers have been generated in the range that you have specified.

  • Was this answer helpful? 00 · 11/15/2011 07:22
Add Your Answer
10~1000 characters in length CAPTCHA:
Related Questions
Q:How to Open an Email Attachment With a Microsoft Excel Worksheet

A:A Microsoft Excel attachment may not open on your computer for several reasons. The most common problem is a lack of the correct software on y...(more)

Q:How to Send a Microsoft Excel 2007 Worksheet As an Email

A:Sending an Excel File Via E-mail Power on your computer and open your e-mail server or log in to your online e-mail. Click the button "New...(more)

Q:How to Hide a Column in Microsoft Excel 2007

A: Click on the column heading located along the top of the worksheet to select the column you want to hide. Go to the "Cells" group on the "...(more)

Q:How to Format Date Strings

A: Open Excel and then open the workbook to which you would like to apply format date strings. Highlight the range of cells you want to forma...(more)

Q:How to Sort by Date

A: Write down an organized list of the information you want to put into Excel and the corresponding dates. Open Excel. Type in the informatio...(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

×