Returns the remainder of given number after it was divided by specified divisor. The result has the same sign as divisor.


=MOD(Number, Divisor)


Name Description
Number The number for which the remainder should be calculated.
Divisor The number by which the Number should be divided

Return Value

The remainder of applied division. Note: it always has the same sign as divisor.


Function Result Comment
=MOD(3, 2) 1 Remainder of 3/2
=MOD(-3, 2) 1 Same sign as divisor
=MOD(3, -2) -1 Same sign as divisor