1. Calculation functions
  2. All Functions
  3. Numeric Functions
  4. MOD

Use the MOD function to return the remainder when one number is divided by another.

If the divisor is 0, MOD returns 0.

Syntax

MOD(dividend, divisor)

The MOD function has the following arguments:

Argument Data type Description
dividend (required)

Number

The number you want to divide.

divisor (required)

Number

The number you want to divide the dividend by.

Constraints

The MOD function has no constraints.

Examples

The following table shows some example formulas using the MOD function.

You can enter values directly into your formula, or reference line items or list properties.

Formula Description Result
MOD(Party.Beverages, Party.Guests)

This example shows how you can include line items or list properties in your formula. In this example, the value of Party.Beverages is 200, and the value of Party.Guests is 30.

20

MOD(26.6, 7.1)

In this example, the MOD function calculates the remainder after 28.6 has been divided by 7.1.

0.2

Excel equivalent