MOD

Returns the remainder of a division.

Syntax:

MOD(a:number, b:number)

MOD gives the remainder (modulo) of the number a divided by the number b.

Note that this function is NOT compatible with Microsoft Excel for negative numbers. If you require behaviour compatible with Microsoft Excel, use ODF.MOD().

Example:

MOD(7, 3)

returns the number 1.