Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

Modify the MOD function for divisors larger than the number
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

As seen in our previous example, a problem occurs when the divisor is larger than the number for which you want to find the remainder. The result will always be the number itself. To handle this using the MOD function, follow these steps.

Handling divisors that are larger than the number:

  1. Select cells A2:A10 and enter 100.
  2. Press Ctrl+Enter.
  3. In cells B2:B10 enter different divisors.
  4. Select cells C2:C10 and type this formula: =A2/B2.
  5. Press Ctrl+Enter.
  6. Select cells D2:D10 and type this formula: =MOD(A2,B2)*(A2>B2).
  7. Press Ctrl+Enter.

Modify the MOD function for divisors larger than the number

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

Modify the MOD function for divisors larger than the number
  1. How to Use the MOD function to extract the remainder of a division
  2. Use the QUOTIENT function to return the integer portion of a division

Article Information

Category
Formula and Function Examples

Tags
, ,

Trackback URI

Comments RSS


Leave a Reply

← How to Use the ISODD and ROW functions to determine odd rows
How to Use a custom format to create a time format →