MOD
Returns the integer remainder resulting from dividing one integer
number by another.
Syntax
MOD(Value1, Value2)
Both arguments are numbers or formulas which return numbers.
Before the calculation both numbers are rounded. The result is then also rounded . This is different compared to Microsoft Excel for example.
The remainder always has the same sign as Value1 (plus or minus), even if it is zero. That is, -0 is possible as result.
Examples
This example returns 0:
MOD(100, 10)
This example returns 2:
MOD(102, 10)
This example returns -3:
MOD(-102.5, 10)