MOD

Returns the reminder of the division of the specified number.

Syntax

MOD( Number number, Number divisor ) → Number

Parameters

number

Required. The number to divide.

divisor

Required. The number to divide by.

Remarks

If divisor is zero, the function returns #DIV/0!.

Example

Formula

=MOD(5,2)
=MOD(-3,2)

See Also

Function Reference
INT Function
ROUND Function
ROUNDDOWN Function
ROUNDUP Function
TRUNC Function
QUOTIENT Function