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 Value

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

Example

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