The MOD function is one of those simple, often overlooked, highly valuable Excel functions.
If I had to pick a Swiss Army Knife of Excel functions, the MOD function would be in the running. Why? Because once you know it, you can find a number of ways to use it.
The MOD function returns the remainder after you divide a number by a divisor.
The syntax is as follows: MOD (Number, Divisor)
For example, MOD (5, 1) would return 0. MOD (5,2) would return 1. MOD (5.5, 1) would return .5.
So now that you know the MOD function, how would you use it?
In upcoming articles, I’ll share tutorials to leverage the power of MOD functions.
In the meantime, here are a few simple ideas. You can use the MOD function to conditionally format cells that meet a certain criteria or prevent your users from entering values that don’t meet the criteria you set. (tag posts for conditional formatting, and add)
Using the MOD function to test for integer values:
MOD (A1,1)=1 will return a TRUE if the number is an integer, and FALSE if it isn’t.
Using the MOD function to test for odd or even numbers:
MOD(A1,2)=0 will return TRUE if the number is an even number, and FALSE if it isn’t.
Do you have an Excel question?
Comment below and it just might make it to a blog post!
About the Author
Jackie Kiadii, Certified MOS Excel Expert, and her team of subject matter expert (SME) trainers provide Microsoft software training that delivers measurable results – increasing productivity, reducing inefficiency, and improving the bottom line. Topics include: Project, Access, Excel, Excel VBA, PowerPoint. Upcoming Excel courses are on our calendar, click here.
Need onsite group training? Call 770.498.7333 or email us. Our courses can be customized to your needs. Jackie has provided software training for employees of The Coca-Cola Company, Emory University, Novelis, and more. This training is available for groups of 4 or more students.