MOD

Description

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

Syntax

MOD ( number, divisor )

Parameter 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