MODULUS Function

Returns the remainder (modulus) that results when a number is divided by a divisor.

Syntax

MODULUS(number, divisor )

Parameters

Name	Required/Optional	Data Type	Description
number	Required	Number	The dividend.
divisor	Required	Number	The divisor.

Return value

Number

Remarks

The result has the same sign as the divisor. A #DIV/0! error is returned if the divisor is 0.

In almost all situations, the MODULUS function should be used rather than the MOD function.

Example 1

MODULUS(5, 1.4)

Returns 0.8.

Example 2

MODULUS(5, -1.4)

Returns -0.6.

Example 3

MODULUS(-5, 1.4)

Returns 0.6.

Example 4

MODULUS(-5, -1.4)

Returns -0.8.