Skip to main content

Mod - script and chart function

Mod() is a mathematical 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.


Mod(integer_number1, integer_number2)

Return data type: integer


integer_number2 must be greater than 0.

Examples and results:  

Examples and results
Examples 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