Good Afternoon John
I hope you are doing well.
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 on my blog, 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.
Was this tip useful? If so, don't keep it to yourself. Remember: sharing is caring.
If you have any questions or would like for us to bring any of our customized training to your office, feel free to call 770.498.7333 or email me.
We are offering a 4-day, in-depth Excel VBA class in January and the early registration discount ends soon. For additional information, please call 770.498.733 or click here.
Enjoy the rest of your week!
Warmly,
Jackie Kiadii, CEO
Phoenix Computer Consultants, LLC
Microsoft Office Specialist Master
t. 770-498-7333
e. [email protected]
w. www.probiztechnology.com
a. 1100 Peachtree Street Suite 200 Atlanta, GA 30309
l. http//www.linkedin.com/in/jkiadii
|
|
What We Do:
Since 2001, Phoenix Computer Consultants LLC has provided Excel and other Microsoft Office training to thousands of business professionals. |
|
Client Feedback:
Thank you for a wonderful learning experience. I have already been able to apply some of the lessons on my Access database project.
Employee - Centers for Disease Control and Prevention |
|
Thanks to everyone who has referred us business over the past 15 years. If you'd like to learn more about our referral program, please click here for the downloadable fact sheet.
Questions? Call 770.498.7333. |
|
|
|
