MOD

Returns the remainder resulting from dividing one number by another.

Syntax

MOD(Value1, Value2)

Both arguments are numbers or formulas which return numbers.

Examples

This example returns 0:

MOD(100, 10)

This example returns 2:

MOD(102, 10)