Number: The number for which you want to find the divisor.; Divisor: The number by which you want to divide the number.; How to use the Mod function in Microsoft Excel. Follow the steps below on ...

The MOD Function Syntax . Before I show you the MOD function in action, let's take a moment to see how it works: =MOD(n, d) where n is the number you want to divide, and d is the divisor. So, if ...

We could use MOD() to check the remainder and, for each month where it is zero, include our payment. Here we've set up columns for our 12 months and on row 3 entered the details of our payment: first ...