MOD

Syntax

MOD (X, Y)

Description

The MOD function returns the remainder of X divided by Y. If Y is zero, MOD returns an error value.

Returns

The remainder of X divided by Y. If Y is zero, MOD returns an error value.

Example

The following examples employ the MOD built-in function:

• MOD(10, 4) returns 2.

• MOD(15, 10) returns 5.

• MOD(15, 5) returns 0.

• MOD(15, 0) returns an error value.