MOD
Returns the remainder after dividing a number by another number.
Returns the remainder after dividing a number by another number.
MOD(number; divisor)
number - the number from which the modulo remainder should be returned - Value type: number
divisor - the number to divide - Value type: number
If divisor is 0, the function returns !DIV0.
number and divisor can be negative and/or floating point numbers as well. Then the standard modulo logic is applied.