The MOD function returns the remainder when two numbers are divided. For example, the formula =MOD(12,2) return the remainder 0.
The function has the following arguments:
number – Required. The number for which division is desired to get the remainder.
divisor – Required. The number to be used for division.
MOD returns the #DIV/0! error value, if divisor is 0. For more detail on the function visit Microsoft Office official website.
Usage of the MOD function
How to determine if a number is even or odd.