Explanation

The MOD function performs the modulo operation.

It takes a number and a divisor and returns the remainder after division.

In this formula, we subtract one MOD result from another.

Excel MOD function

For the second MOD, we use the number with a divisor equals to the place value we seek.

For example, MOD(10,3) = 1.

The result of MOD carries the same sign as the divisor.