MOD Function (Gnumeric)

The worked formula below shows the argument order used for this example. Consult the linked software-specific function reference for optional parameters and edge cases.

Gnumeric formulas normally use commas (,) between arguments. These examples are written for Gnumeric rather than copied unchanged from LibreOffice Calc.

=MOD(17,5)

Expected result: 2.

Why it works: Calculate the remainder after division.

Practice inputs: No worksheet cells are required.

=MOD(19,5)

Expected result: 4.

19 divided by 5 is 3 with remainder 4, so MOD returns 4.

What to watch for

MOD divides by its second argument, which must not be zero.

For LibreOffice Calc formulas, separators are commonly semicolons; the Gnumeric examples here use commas. The arithmetic or official reference supplies the expected result, but Gnumeric has not been executed for this review.

• Gnumeric mathematics function documentation

1. Identify the cells or inputs that correspond to the sample values above.
2. Enter the formula in an empty cell, changing the references or literal values to match your sheet.
3. Compare the output with a manual check on a small known example.
4. Extend the formula to a larger dataset only after you understand the result.

• Check the accepted numeric domain, units and array dimensions for the specific operation.
• If an error appears, check that the function arguments are of the expected type.
• A pasted formula may produce an error when it uses the other program’s argument separator or unsupported options.

ABS ROUND ROUNDUP ROUNDDOWN SUM.

• Gnumeric official function reference
• Gnumeric function catalog
• The function name was checked against the official reference. A comparable example passed in LibreOffice Calc 25.2, but the example was not executed in this application. Confirm on your installed version before depending on it.