MOD

This function returns the remainder of a division operation.

MOD(dividend,divisor)

This function has these arguments:

Argument	Description
dividend	Number for which you want to find the remainder by dividing the divisor into it
divisor	Number by which you want to divide the dividend argument

The remainder has the same sign as the divisor.

Accepts numeric data for both arguments. Returns numeric data.

MOD(B3,10)

MOD(C4,B2)

MOD(R1C2,12)

MOD(255,16) gives the result 15

MOD(-3,2) gives the result 1

This function is available in product version 1.0 or later.