MOD

The MOD function divides one number by another and returns the remainder of the division. It is commonly used in calculations involving cyclic patterns, intervals, or determining whether a number is divisible by another number.

Syntax

MOD(dividend, divisor)

Arguments

• dividend: The number to be divided.
• divisor: The number by which the dividend is divided.

Return value

Returns the remainder after division.

Example

MOD(Planned Units, 2)

In this example, the MOD function is used to create the Remaining Units measure, which returns the remainder after dividing the Planned Units values by 2.

Excel equivalent

MOD