Use =QUOTIENT(numerator, denominator). This is the exact English argument order in ONLYOFFICE’s official QUOTIENT reference. The guide gives reproducible input data and expected outputs independently checked with Python decimal arithmetic; it does not claim any native ONLYOFFICE execution.

When inventory is packaged in cartons, a rate is counted in complete units, or a cut list requires whole components, QUOTIENT removes the fractional part of a division. It does not round to the nearest integer and does not return a remainder. For instance, 17 items packed five to a box yield three complete boxes. The official ONLYOFFICE QUOTIENT reference states that the function returns the integer portion of division and names the two numeric arguments.

=QUOTIENT(numerator, denominator)

The official argument table lists 2 required numeric arguments, with no optional parameters or defaults stated. Placeholder names in the syntax are not values; replace them with appropriate numeric literals, references or expressions. A referenced cell containing number-formatted text should not be treated as safely numeric without checking the installed build.

The function-specific ONLYOFFICE English reference documents the signature and purpose but not detailed behaviour for division by zero, numeric text, spreadsheet errors or implicit conversions. For negative-number cases, the expected results use truncation toward zero, in line with the independently checked Microsoft Excel function contract; reproduce them natively before declaring build-specific compatibility.

this guide uses the unversioned English ONLYOFFICE Docs Spreadsheet Editor function catalogue and the function-specific article, each accessed 2026-10-11 UTC. The article documents the function name and English syntax, but does not name the first supported release. The catalogue documents available functions for Docs; it is not a tested compatibility matrix for all server builds, Desktop Editors, mobile apps, or embedded integrations. No actual Docs web or Desktop installation was available to execute the examples. A product-release banner is not evidence that this function behaves identically in every edition or build.

For the English formulas in this guide, type =, then the function name and parentheses; the official insertion instructions show that multiple arguments use commas. The Advanced Settings reference documents a Formula Language selector and regional configuration. Localized function names, decimal punctuation and argument separators may differ; verify these on the actual user installation. Data below use a period as decimal separator. A displayed number format is not proof of the stored numeric value.

Enter numerator values in column A and divisors in column B. Keep the zero-divisor guard case on row 11, rather than evaluating QUOTIENT directly there.

Enter the formula

=QUOTIENT(A2,B2)

1. Open a new worksheet and enter the table numbers as numeric cells, not quoted strings. For signed numbers, use the minus sign before the digits.
2. Select the result cell next to the first row. Enter the formula shown below, using the English punctuation.
3. Fill down through the example range. For the QUOTIENT zero-divisor case, enter the separate IF guard formula instead of an unguarded division.
4. Compare outputs to the independently calculated expected results in the table and companion CSV. The values here have not been observed running in ONLYOFFICE.
5. Change a copy of one input at a time, and document the program version and actual result for any discrepancy. Do not overwrite the original test cells.

The table shows expected results, not screenshots or native observations. The companion data/math-integer-fixtures.csv preserves the corresponding explicit formulas and inputs. Zero, negatives and decimal inputs are included to make differences visible.

Count only finished cartons

=QUOTIENT(A2,B2)

Expected output: 3. 17 units at five per carton fit in three complete cartons, with two units left over; partial cartons require a different policy. This is independently reasoned, not a native ONLYOFFICE observation.

Check what remains after dividing

=MOD(A2,B2)

Expected output: 2. MOD returns a remainder, not the whole-unit count. The ONLYOFFICE MOD reference documents its separate purpose. This is independently reasoned, not a native ONLYOFFICE observation.

Make a zero divisor safe to review

=IF(B11=0,"CHECK DIVISOR",QUOTIENT(A11,B11))

Expected output: CHECK DIVISOR. B11 is zero. IF selects a visible warning, avoiding reliance on an unverified zero-division error for the function itself. This is independently reasoned, not a native ONLYOFFICE observation.

See why negative division differs from INT

=TRUNC(A5/B5)

Expected output: -3. A5 is −17 and B5 is 5. Truncating −3.4 toward zero gives −3. INT would go down to −4, so the two are not interchangeable for negatives. This is independently reasoned, not a native ONLYOFFICE observation.

A numerical distinction worth checking

For the signed example -17/5, three different concepts appear: the exact division is −3.4; the expected integer portion by truncation toward zero is −3; and a mathematical floor would be −4. This distinction matters in reversals, debit/credit offsets and manufacturing waste calculations. Do not substitute INT merely because both formulas return integers for positive numbers.

When not to use this function

If a shipment needs enough full cartons to cover every item, you usually need ceiling-style capacity rather than complete-carton count. If you need the leftover items, use MOD; if you need an average rate or a fractional yield, ordinary division keeps the decimal part.

1. Swapping numerator and denominator: =QUOTIENT(17,5) is not the same question as =QUOTIENT(5,17).
2. Thinking the result is a rounded quotient: =QUOTIENT(17,5) expects 3, not 4; the fraction is discarded.
3. Using QUOTIENT when partial packs must be purchased: needing enough boxes generally calls for a round-up business rule, not completed-box counting.
4. Using INT(A5/B5) with negative inputs: floor and truncation toward zero differ.
5. Passing a zero denominator: the ONLYOFFICE QUOTIENT page does not document its exact error value. Use the shown IF guard and test a controlled error case natively.
6. Entering numeric text or arrays and assuming automatic coercion: the primary documentation specifies numeric arguments but does not define all conversion/error rules.

1. Formula displays literally rather than calculating. Check that it starts with = and that the result cell is configured to accept formulas rather than text. Insert the function from the Formula tab if unsure.
2. Function name is unknown or arguments are rejected. Search the installed Insert Function dialog for the function; confirm the exact edition/build, formula language, regional separator and copied punctuation.
3. Result differs from an example. Compare the raw input cells, numeric types and signs. Check whether a value merely looks rounded due to display formatting. Compare against the expected-results CSV rather than an unrelated screenshot.
4. Excel output differs from ONLYOFFICE. Use the same literal inputs, cell number formatting and locale in both programs, compare actual build versions and save a minimal test case. Do not call it a vendor defect without reproducing it.
5. Need an audit trail. Save the exact input workbook, the function formula, output cells, screenshots where permitted, operating system, product edition/build and regional settings. The original inputs should remain unchanged.

Microsoft Excel: its official QUOTIENT documentation likewise describes an integer portion, with truncation toward zero illustrated by numeric logic. Excel documents errors for certain invalid types, but that is not proof that ONLYOFFICE emits identical error codes in every build. For transfers between Excel, ONLYOFFICE Docs web, Desktop Editors and other engines, retest decimal, negative, zero-divisor and text-typed numeric inputs in both applications.

• Current ONLYOFFICE Docs English help: documents name, purpose and argument signature. That is documentation checking, not native build testing.
• ONLYOFFICE Desktop Editors: same-brand product, but the current Docs function article does not document a first supported Desktop version. Desktop testing remains pending.
• Mobile and integrations: not established by this documentation alone. Test relevant embedded implementations before describing them as compatible.
• Other spreadsheet engines: a shared function name is not a guarantee of matching coercion, error types, sign rules or locale treatment.

Microsoft’s official Excel QUOTIENT function article was checked as cross-software comparison evidence only, not as proof that ONLYOFFICE behaves identically for edge cases.

These vendor references were checked as documentation links, not as live internal Spreadsheet-Tutorials.com pages:

• MOD — official ONLYOFFICE function reference
• TRUNC — official ONLYOFFICE function reference
• IF — official ONLYOFFICE function reference
• INT — official ONLYOFFICE function reference

• ONLYOFFICE Spreadsheet Editor — function documentation
• function catalogue
• Advanced Settings reference
• MOD — official ONLYOFFICE function reference
• TRUNC — official ONLYOFFICE function reference
• IF — official ONLYOFFICE function reference
• INT — official ONLYOFFICE function reference

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.