MOD

Returns the remainder after dividing a number by another number.

Syntax

MOD(number; divisor)

  1. number - the number from which the modulo remainder should be returned - Value type: number

  2. divisor - the number to divide - Value type: number

Remarks

  1. If divisor is 0, the function returns !DIV0.

  2. number and divisor can be negative and/or floating point numbers as well. Then the standard modulo logic is applied.

Examples