ONLYOFFICE #DIV/0!: Diagnose a Zero Denominator
Scope: ONLYOFFICE Spreadsheet Editor English function documentation checked October 21, 2026. The help pages are not pinned to an installed build. Record whether you use free Desktop Editors or a hosted editor, its version and platform; these examples do not certify older builds, mobile editions or desktop/server parity. No application was executed for this reference. Use a disposable workbook; expected results are documentation-based checks, not native observations.
Identify the ratio’s meaning
The ONLYOFFICE IFERROR reference includes #DIV/0! among recognized errors and uses a division-by-zero scenario. Start by inspecting the denominator in your actual formula. Is it a count, duration, baseline amount or calculated difference? A replacement is justified by that meaning, not merely by whether it makes the error disappear.
Check whether the issue occurs in a workbook created in ONLYOFFICE or only after importing it. If the latter, preserve the original and compare the formula and its direct inputs before blaming compatibility. The imported-formula diagnostic covers that broader investigation.
A controlled cost-per-unit test
Use a new sheet with these numeric entries:
| Cell | Entry | Meaning |
|---|---|---|
| A2 | 96 |
Batch cost |
| B2 | 0 |
Completed units |
| C2 | =A2/B2 |
Cost per completed unit |
The expected result in C2 is #DIV/0!. The batch cost is known, but a unit cost is undefined when no units are completed. This does not imply that the batch was free.
Change B2 to 12. C2 should become 8. Change A2 to 120 and verify 10; change B2 to 24 and verify 5. Restore A2 to 96 and B2 to 0. These independent arithmetic controls distinguish a repaired dependency from a value typed over the formula.
Decide which correction is legitimate
If the count was entered incorrectly, replace it with the verified count. If the count is truly zero, use a clearly labelled exception in the report. If the count has not yet been recorded, retain that missing-data distinction instead of silently assigning zero.
For the known numeric exercise, =IF(B2=0,"No completed units",A2/B2) is a targeted reporting rule. The official IF reference describes separate true and false outputs. The rule checks this one zero condition; it is not comprehensive validation of blanks, text, negative quantities or every upstream failure. Define those policies separately for real records.
A text message also changes the result column’s meaning. Keep raw inputs and an explicit status field available for later review; do not assume downstream summaries will count or display text exceptions as you intend.
Test before sharing a repaired file
Check a positive quantity, a genuine zero quantity and a missing-input row separately. Verify the formula still responds to a cost change. Save the repaired workbook under a separate name and compare its important outputs before replacing any working copy.
Do not apply IFERROR(...,0) across the workbook as a cleanup step. The function handles multiple error families, so a broken reference can be hidden along with zero division. Use IFERROR only after defining the fallback’s meaning. For a formula that appears not to update, consult calculation checks rather than altering valid inputs.