Related Function:

The MOD function returns the remainder of a division between two number. The result has the same sign as divisor.

Syntax

=MOD(number,divisor)

Arguments

Argument Description
number The number to be divided
divisor The value that divides the number argument

Examples

  A B C
1 Formula Result Notes
2 =MOD(3,2) 1 Remainder of 3/2
3 =MOD(-3,2) 1 Remainder of -3/2. The sign is the same as divisor
4 =MOD(3,-2) -1 Remainder of 3/-2. The sign is the same as divisor
5 =MOD(-3,-2) -1 Remainder of -3/-2. The sign is the same as divisor

Common Function Error(s)

Problem What went wrong
#DIV/0! Occurs if divisor is 0