Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

Use the RANDBETWEEN function to generate random values in a specified range
Addicted To Cialis Medrol Packs Buying Viagra Over The Internet Bio Brite Sun Alarm Can Plavix Substitute For Coumadin Viagra And Affiliate Breast Augmentation Discussion Boards Natural Herb For Lasix Plavix And Inr Breast Enhancement Capsules Ultra Curves Estrogen Coral Calcium Supreme 240 Zelnorm Affects Birth Control Patti Labelle Clas Of The Choirs Benefit Of Coral Calcium Hgh Effects On Teens Buy Hgh Buy Hgh Buy Hgh Anoretic Cardura Medication Leukeran Pet Medication Levitra For Females Out Of Court Settlement For Viagra Prednisone Prescribing Lamictal Bipolar 1 Aleve Pregnancy Coumadin Anticoagulation Drug Interaction Cipro Zoloft And Sudafed Plavix And Aspirin Interactions Use Zovirax For Effective Herpes Treatment Medrol Dose Pack And Crohns Synthroid Hot Flashes Geodon Im Cialis Manufacturer Jewish Purim Cookies Squill And Lipitor Synthroid Destroys Thyroid Advil Or Motrin Atarax Prescribing Information Flonase For Kidney Stones Lotrisone Cr 30 Mg Cost Of Viagra In The Philippines Can I Take Prozac At Night Zoloft Cleft Palatte Benefit Of Coral Calcium 0a North Beach Pizza Soma San Francisco Viagra Over Counter Herb Valproic Depakote Hypothalmus Hoodia Tlc Lasix Veterinary Dose Of Tramadol Neurontin Use

To generate randomized values in a specified range, such as from 1 to 49, use the RANDBETWEEN function. This function returns a random number in the range you specify, returning a new random number every time the worksheet is calculated. If this function is not available and returns the #NAME? error, install and load the
Analysis ToolPak add-in. Here is the syntax that is used:
RANDBETWEEN(bottom, top)
bottom: The lowest integer in the range.
top: The highest integer in the range.

To create random values from 1 to 49:

  1. Select cells A2:D10 and type the following formula: =RANDBETWEEN(1,49).
  2. Press Ctrl+Enter.
  3. Press Ctrl+C to copy the filled cells.
  4. From the Edit menu, select Paste Special.
  5. In the Paste Special dialog box, select the Values option button to paste only the values, and click OK.

Use the RANDBETWEEN function to generate random values in a specified range

Random values are sometimes used for mathematic studies or for programming a lottery.

This tip is compatible with Excel 97, 2000, 2003 and 2007.

Use the RANDBETWEEN function to generate random values in a specified range
  1. How to Use the RAND function to generate random values in Excel
  2. Using the SUM function to Sum a Range of Values in Excel
  3. How to Use the MAX function to find the largest value in a range
  4. How to use the COUNTIF function to count values in Excel
  5. How to Use the PRODUCT function to multiply values in Excel

Article Information

Category
Formula and Function Examples

Tags
, , ,

Trackback URI

Comments RSS


Leave a Reply

← How to Use the RAND function to generate random values in Excel
Use the EVEN and ODD functions to determine the nearest even/odd value →