Mod()

Working with Formulas > Functions Used in Formulas > Numeric Functions > Mod()

MOD() returns the remainder of the numerator divided by the denominator.

Function Format

MOD(numerator, denominator) 

Return Value

MOD() returns a numeric value 

Examples

MOD(9, 3) = 0 

MOD(10, 3) = 1 

MOD(-10, 3) = -1 

MOD(10.2, 3) = 1.2