Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

Use the MROUND function to round values to the nearest multiple of 10 or 50
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

Sometimes it is necessary to round up values to the nearest multiple of 10 or 50. To perform this task, use the MROUND function from the Analysis ToolPak add-in. MROUND returns a number rounded to the desired specified multiple.

To round values to the nearest multiple of 10 or 50:

  1. In cells A2:A10 list any kind of values.
  2. Select cells B2:B10 and type the following formula: =MROUND(A2,10).
  3. Press Ctrl+Enter.
  4. Select cells C2:C10 and type the following formula: =MROUND(A2,50).
  5. Press Ctrl+Enter.

Use the MROUND function to round values to the nearest multiple of 10 or 50

To use this function, you need to have the Analysis ToolPak installed and loaded as described here.

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

Use the MROUND function to round values to the nearest multiple of 10 or 50
  1. Use the FLOOR function to round down values to the nearest 100
  2. How to Use the CEILING function to round up values to the nearest 100
  3. How to Use the MROUND function to round prices to 5 or 25 cents
  4. How to Use the ROUND function to round time values to whole minutes
  5. How to Round Time to the nearest 15 minute in Excel

Article Information

Category
Formula and Function Examples

Tags
,

Trackback URI

Comments RSS


Leave a Reply

← Convert Miles per hour to Km per hour in Excel.
How to Use the RAND function to generate random values in Excel →