Use =MOD(number,divisor) for the remainder after dividing a number by a divisor. If 17 items go into packs of 5, =MOD(17,5) has an expected remainder of 2. A zero divisor gives the officially documented #DIV/0! error.

Find leftovers after division, group repeating records and detect divisible quantities. The examples are designed for a spreadsheet you can create yourself, so no sample download or proprietary data is needed. Only the function’s explicitly documented behaviour is attributed to ONLYOFFICE; sample outputs are described as expected, not observations.

=MOD(number, divisor)

The ONLYOFFICE MOD reference documents this exact order and the #DIV/0! error when divisor is zero. It does not explicitly document the sign rule for negative dividends/divisors, so this page avoids presenting Excel’s sign rule as a tested ONLYOFFICE fact.

Documentation scope: The signature and core purpose above are documented by the unversioned English ONLYOFFICE Docs Spreadsheet Editor function reference, checked 11 October 2026 (UTC). That confirms help-site documentation, not a universal guarantee that the function behaves identically in every installed release, browser integration, mobile app, or Desktop Editors build. The referenced Docs release history and distinct Desktop Editors release history were checked; neither establishes a first-supported version for this function. First-supported Docs/Desktop/mobile versions: UNKNOWN; target-version native compatibility: NOT TESTED.

In English examples, formulas begin with =, function arguments are enclosed in parentheses, and multi-argument functions use a comma (see ONLYOFFICE’s formula-entry instructions). Under File → Advanced Settings, formula language and region can be changed; the official regional settings instructions discuss locale and decimal/thousands separators. Do not blindly substitute semicolons or localized function names: confirm the target editor’s language, regional settings and argument separator. All sample decimals below use a dot and English function names.

How to try the examples

1. Create a new blank worksheet. Enter the input table below into the specified cell addresses; enter numeric values as numbers rather than quoted strings.
2. Enter each formula in its listed output cell, beginning with =. Choose Formula → Function to use the arguments wizard if necessary.
3. Compare with the values marked independently calculated expected results, not observed ONLYOFFICE outputs. Set the output cells to General or Number format as appropriate.
4. Keep original input values unchanged so the formulas can be independently checked, and log discrepancies against the installed software version and locale before relying on the result.

Copy the simple =MOD(A2,B2) pattern from C2 through C7 only after entering all inputs. Each stated numeric output is independently arithmetic-checked; the error is documented, not observed in an installed editor.

Build a packing dashboard and 1-based repeating label

To distinguish a full pack from a partial one, place this in D2:

=IF(MOD(A2,B2)=0,"Exact packs","Leftovers")

With 17 items and pack size 5, the expected label is Leftovers; in D4 with 20 items and size 4 the label is Exact packs. This uses the documented IF signature. Avoid copying to row 6 until invalid divisor data is handled, because MOD(...,0) is a real error, not a valid no-leftover result.

For a repeating 1-based position within each pack, use =MOD(A2-1,B2)+1. With the row-2 inputs it gives 2: (17-1) mod 5 +1 = 1+1. The -1/+1 shifts a zero-based remainder into labels 1 through 5. This is appropriate for positive integer item counts and pack sizes, not unrestricted negative/decimal inputs.

If you need whole packs as well as leftovers, INT documents integer flooring: =INT(A2/B2) would be 3 for 17/5. Check that B2 is positive before trusting the quantity.

Negative-case test plan, not an asserted native result: Type =MOD(-3,2) and =MOD(3,-2) in a scratch sheet. Microsoft’s Excel MOD reference says the Excel results are 1 and -1 respectively; do not label those as observed ONLYOFFICE results until executed there.

Excel’s MOD documentation shares MOD(number,divisor), reports #DIV/0! for zero divisor and specifies the remainder has the divisor’s sign. LibreOffice Calc separately documents mathematical functions and often displays argument syntax with semicolons. ONLYOFFICE’s current MOD page documents remainder and divide-by-zero, but does not provide a negative-sign convention; that difference in documented detail is not proof of a runtime behavioural difference. Keep negative-input portability unverified.

• ONLYOFFICE INT — integer part of quotient.
• ONLYOFFICE IF — label exact packs versus leftovers.
• ONLYOFFICE ABS — distance from zero; not interchangeable with a remainder.

• ONLYOFFICE Spreadsheet Editor — function documentation
• Docs release history
• Desktop Editors release history
• ONLYOFFICE’s formula-entry instructions
• official regional settings instructions
• documented IF signature
• INT

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

• No genuine ONLYOFFICE Spreadsheet Editor screenshots are included; this guide does not use mock application images.