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. 

Feel free to Download the Workbook HERE.

Free Excel Download

Leila Gharani

I'm a 6x Microsoft MVP with over 15 years of experience implementing and professionals on Management Information Systems of different sizes and nature.

My background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert, SAP BW Project Manager. My passion is teaching, experimenting and sharing. I am also addicted to learning and enjoy taking online courses on a variety of topics.