MOD function
Summary
Returns the remainder from division
Syntax
MOD(number, divisor)
The MOD function syntax has the following arguments:
• Number Required. The number for which you want to find the remainder.
• Divisor Required. The number by which you want to divide number.
• Number Required. The number for which you want to find the remainder.
• Divisor Required. The number by which you want to divide number.
Example
=MOD(3, 2)
=MOD(-3, 2)
=MOD(3, -2)
=MOD(-3, -2)
=MOD(-3, 2)
=MOD(3, -2)
=MOD(-3, -2)