Skip to main content

Mod

Mod() is a modulo function that returns the non-negative remainder of an integer division. The first argument is the dividend, the second argument is the divisor, Both arguments must be integer values.

Syntax:  

Mod(integer_number1, integer_number2)

Return data type: integer

Limitations:  

integer_number2 must be greater than 0.

Examples and results:  

  • Mod( 7,2 ): returns 1
  • Mod( 7.5,2 ): returns NULL
  • Mod( 9,3 ): returns 0
  • Mod( -4,3 ): returns 2
  • Mod( 4,-3 ): returns NULL
  • Mod( -4,-3 ): returns NULL

See also: