MOD in Zoho Sheet: Remainders, Negative Numbers, and Cyclic Groups

=MOD(number; divisor)

Zoho’s MOD help article describes integer division, explicitly gives the result the sign of the divisor, and documents the identity:

MOD(number;divisor) = number - divisor * INT(number/divisor)

The identity depends on INT rounding down rather than truncating toward zero. The source’s examples include MOD(442;12) = 10, MOD(-23;5) = 2 and MOD(25;-2) = -1. For production use with noninteger operands, extreme magnitudes, or special datatypes, native Zoho testing is still needed because the public description frames the arguments as integers.

Open the accompanying math-sign-and-rounding-practice.csv in Zoho Sheet. Paste or import it with the first row at A1. For this guide, C contains integer adjustments or item counts and D contains divisors; the other columns provide context for the related ABS, INT, SIGN and TRUNC articles. Treat columns C and D as numeric cells, not strings.

Step by step: calculate remainders

1. Type Remainder into E1.
2. In E2 enter =MOD(C2;D2); the expected answer is 1 because 25 = 2 × 12 + 1.
3. Fill E2 down through E9.
4. Compare E3 to 2. Although C3 is -23, the positive divisor 5 produces a positive remainder: -23 = (-5 × 5) + 2.
5. Compare E5 to -1. Here C5 is 25 and D5 is -2: 25 = (-13 × -2) + (-1).
6. Expect E8 to show a division-by-zero error, not a blank, zero, or normal remainder. Correct the divisor before using the row in a report.

The sign rule is easier to check with the documented INT identity. For E5, INT(25/-2) is -13, not -12. The corresponding remainder is 25-(-2*-13) = -1. Replacing INT with TRUNC here would give a different answer and would be a mathematical error.

Suppose sequential positive item IDs should be distributed over three bins labeled 1, 2 and 3. Put an integer item ID in C2 and enter:

=MOD(C2-1;3)+1

With C2 = 25, the expected bin is 1; if an ID is 26, it is bin 2; if it is 27, it is bin 3. Subtracting 1 before MOD and adding 1 afterward makes the cycle use labels 1–3 rather than 0–2. This expression assumes positive integer IDs; the naming rules for zero or negative IDs should be defined separately.

For an input divisor that may be zero, use a business-facing warning:

=IF(D2=0;"Fix divisor";MOD(C2;D2))

When D2 is 12, the independently predicted output is 1; when D8 is 0, the intended output is Fix divisor rather than #DIV/0!. This combined IF/MOD behavior still requires validation inside Zoho Sheet, particularly if an imported workbook has unexpected types or calculation settings. If preserving hard errors is required for audits, do not suppress the zero-divisor error.

A third application is checking multiples of a positive unit size: =MOD(C2;5)=0 predicts TRUE for 25 and FALSE for 17. Only use that test on integer counts if the business rule is about complete units.

MOD returns the remainder, not the quotient. For positive C2 = 25 and D2 = 12, a complete-group count would be =INT(C2/D2) → 2, whereas =MOD(C2;D2) → 1 item left over. Do not conflate group count and leftover count on a packing report.

For negative operands, the distinction becomes more important. INT(-23/5) is -5, and MOD(-23;5) is 2. Truncating -4.6 toward zero would be -4 and would not reconstruct the expected remainder. INT and TRUNC explain that difference. SIGN categorizes a signed number and ABS returns magnitude; neither performs division.

Zoho’s generic possible-errors list also includes #N/A!, a general spreadsheet condition; it does not establish a lookup operation inside MOD.

Microsoft Excel’s current MOD article separately confirms the same divisor-sign rule and the INT identity. Its English syntax is MOD(number, divisor) with a comma, whereas Zoho’s published mathematical article shows MOD(number; divisor) with semicolons. Formula punctuation may depend on locale and editor; copy the form shown by the target application’s help or in-editor suggestions. Google Sheets has a MOD function as well, but this article does not treat the shared name as proof that special cases and string coercion match.

Zoho’s current function reference does not assign an exact first-supported version. Zoho’s 2026 desktop-beta announcement describes broad but not exhaustive feature parity, so this page does not assert identical offline behavior for all configurations.

• Zoho Sheet — function documentation
• Zoho INT function

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.

• No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.