You are here: All Help Topics > Other Information > Cell Functions > MOD function

MOD Function

The MOD function calculates the remainder when one number, the numerator, is divided by another, the divisor.

MOD(numerator,divisor)

MOD(11,2)

Returns the value 1, which is the remainder of 11/2.

MOD(-13,5)

Returns the value -3, which is the remainder of -13/5.

  • If the divisor is 0, then you will receive the warning #DIV/0!

Related Topics