MOD

Description Returns the remainder after dividing a number by a specified divisor.

Syntax MOD ( number, divisor )

Argument	Description
number	Any number.
divisor	Any nonzero number. If divisor is 0, #DIV/0! is returned.

Examples This function returns 1:

MOD(-23, 3)

This function returns -2:

MOD(-23, -3)

See Also INT, ROUND, TRUNC