Excel 2007 has a built in random number generator.
The Microsoft Office 2007 suite of applications includes PowerPoint, Excel, and Word. If you want a random number generated for a raffle, a dice program, or any other application, then Microsoft Excel 2007 has a built in function called RAND that can do the job for you. The RAND function will give you an evenly distributed random number between 0 and 1. It can be modified to return a random number in a range.
Instructions
1. Open Microsoft Excel by double clicking on the Desktop icon. If you don't have a desktop icon, click on the "Start" or "Windows" button and then click on "All Programs." Click on "Microsoft Office 2007" and then click on "Microsoft Excel 2007." Excel will open with a blank spreadsheet.
2. Click on the cell in which you want the random number generator.
3. Type "=RAND()*(b-a)+a" into the cell.
4. Change "a" and "b" in the RAND function to show your maximum and minimum numbers. For example, =RAND()*(100-1)+1 will display a random number between one and 100, and =RAND()*(1,000,000-1)+1 will display a number between one and one million. If you want a number between 0 and 1, delete the variables, leaving RAND() in the cell.
5. Press the "Enter" key. Excel will generate a random number and place it in the cell.
Tags: number between, random number, Excel 2007, Microsoft Excel, Office 2007, random number, 2007 built