MOD

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

Syntax

=MOD(Number, Divisor)

Arguments

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

Return

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

Examples

Formula	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