MOD (Primitive Spread Function) returns the remainder after the Number argument (dividend) is divided by the Divisor argument.

SYNTAX:

MOD(Number,Divisor)

REMARKS:

Arguments are as follows:

Argument Description 
Number Number for which you want to find the remainder (dividend) 
Divisor Number by which you want to divide the Number argument 

The remainder has the same sign as the Divisor argument.

EXAMPLES:

MOD(B3,10)
MOD(C4,B2)
MOD(255,16)=15
MOD(-3,2)=1