Here’s a simple explanation of Excel’s MOD formula and how it can be used to solve real business cases.
This explains the MOD function in simple terms and shows you three different practical cases.
Excel MOD is shown as follows:
1. Grouping participants into groups of 6, 3 or 4. Which is better? i.e. has less people left over.
2. Reporting quarterly data
3. Controlling the occurrences of data labels in charts. For example, you have a line series and you’d like to show the data label for every 2nd, 3rd or 4th occurrence.
What does the MOD function do?
By definition, it returns the remainder after one number is divided by another.
We can classify whole numbers into certain groups. For example, Odd and Even, or numbers that are divisible by two, by three, four, and so on.
This is what the MOD function does. It checks if a number is divisible by another number and if not, how far away is it from being divisible.
The key here, is that MOD looks backwards – i.e. to the next smaller number that was divisible and then count. MOD works the same with negative numbers.
This video gives an example:
The new Excel Dashboards course is here!
Now available on Udemy
Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.