Skip to main content

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

NameDescription
NumberThe number for which the remainder should be calculated.
DivisorThe number by which the Number should be divided

Return Value

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

Example

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