Returns the remainder of a division.
Syntax:
MOD( dividend:Number, divisor:Number )
MOD
gives the remainder (modulo)
of the number dividend
divided by the number divisor.
The remainder given by MOD
has the same sign as the dividend.
Note that this behaviour is NOT compatible with OpenDocument / Microsoft Excel MOD
for negative numbers.
If you require compatibility with OpenDocument / Microsoft Excel, use ODF.MOD().
Example:
MOD(7, 3)
returns the number 1
.