CEILING.MATH Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

• Introduced: The original introduction version and date are not established by the official sources checked.
• Availability: Documented in the current ONLYOFFICE Spreadsheet Editor help; no final working-version endpoint is established.
• Scope: Docs and Desktop Editors release separately. This unversioned help does not establish availability in every older build, mobile client or deployment.
• Checked: October 14, 2026, against the official function reference. Documentation check; not a new native test.

Set consistent business increments while controlling the direction used for negative values. The documented English-language formula is CEILING.MATH(number) with additional optional parameters where shown below. All numerical outcomes below are independently derived worksheet expectations, with the official documentation cited for the exact signature and explicit error notes.

Round upward to an integer or increment while choosing the direction for negative inputs. For positive values, round to the next full increment. For negative values, the mode parameter determines whether to choose the step closer to zero (mode 0) or farther from zero (other numeric mode).

A multiple is not the same thing as a decimal-place count. With 2-unit increments, permitted results are 0, 2, 4, 6, 8 and so on; a request to round to two decimal places is a different calculation. The most important choice is whether your business rule requires an upper boundary, a lower boundary, or the nearest boundary. See the comparison section below before substituting similar function names.

=CEILING.MATH(number, [significance], [mode])

Documentation-confirmed status: ONLYOFFICE’s CEILING.MATH reference identifies this name and argument order. Square brackets in the help text denote optional arguments; they are not characters to type into a worksheet. The significance default is 1 and the mode default is 0, exactly as described in the ONLYOFFICE function article.

Meaningful error/domain caution: The official CEILING.MATH function page does not provide a complete error-code table; do not manufacture an error string for zero significance, text or other invalid inputs. If you need an exact error string for unmentioned invalid inputs, test the target editor rather than importing a rule from Microsoft Excel or another spreadsheet.

1. Open an empty sheet and use row 1 for column labels. Enter each numeric value from the table below into the indicated B, C, and D cells, without currency symbols or units embedded as text.
2. Keep the scenario labels in A only; labels are explanatory and are not part of the calculation.
3. Enter the formula for row 2 in the indicated formula column, or type each listed row formula verbatim. Use English function names and comma argument separators for this example workbook.
4. Compare the displayed output against the independently expected number. If your regional settings use another separator or translated function name, use the settings-aware form rather than assuming these literal commas work in every locale.
5. Keep raw measurements separate from formatted outputs: changing displayed decimal places does not necessarily change the numeric value used by rounding.

How to check the arithmetic: For row 2, =CEILING.MATH(B2,C2,D2) has an independently expected output of 6. Work from the original number and increment rather than the displayed precision. These rows are examples you can enter yourself; none is claimed to have been executed in the ONLYOFFICE app.

Enter these into empty cells on a test sheet:

Validation method: For regular numerical cases, the expected outcomes were calculated with Python Decimal arithmetic and matched to the examples without invoking an ONLYOFFICE calculation engine. The CEILING.MATH function signature and any explicitly labelled vendor error text were checked against the official page; other platform-specific behaviour remains untested.

Price bands including adjustments or credits

Imagine B12 = −4.30 as a signed adjustment and C12 = 2 as the pricing increment. =CEILING.MATH(B12,C12,0) has an independently calculated expectation of −4, whereas =CEILING.MATH(B12,C12,1) expects −6. This is a policy decision, not merely a presentation setting: document which direction your accounting rules require before using this transformation.

For positive capacity B13 = 37 and C13 = 8, =CEILING.MATH(B13,C13) expects 40 units of capacity. =CEILING.MATH(B13/C13,1) expects 5 packages. Remember that CEILING.MATH rounds a quantity; it does not infer the unit or count for you.

Mode argument is numeric, not TRUE/FALSE semantics

The vendor describes mode as a numeric argument: omitted/0 for toward-zero negative rounding; any other numeric value for away-from-zero. Avoid claiming that textual values or booleans have a guaranteed interpretation. When saving a workbook for an older release or importing an XLSX, check availability and returned values in the actual edition.

Migration from legacy CEILING

Do not replace CEILING(-4.3,2) with CEILING.MATH(-4.3,2) expecting the same outcome. The old function documents an opposite-sign #NUM! error; the newer variant documents a meaningful negative-value mode. CEILING.PRECISE is another separately named catalogue function, not an alias for this mode-aware signature.

If a workbook shows a general formula error, first confirm that the number of arguments, function spelling, argument separator and value types match the target editor’s settings. The short vendor reference does not justify a complete type-coercion/error-code matrix; do not present guessed #VALUE!/#DIV/0! results as ONLYOFFICE-tested facts.

CEILING.MATH documents the default significance 1 and default mode 0. For negative values, mode 0 or omitted rounds toward zero; any other numeric mode rounds away from zero. Positive numbers are not affected by mode.

Related vendor references (these are separate documented entries, not guaranteed cross-version aliases):

• CEILING official ONLYOFFICE reference — a separate documented function; not an alias for CEILING.MATH.
• CEILING.PRECISE official ONLYOFFICE reference — a separate documented function; not an alias for CEILING.MATH.
• FLOOR.MATH official ONLYOFFICE reference — a separate documented function; not an alias for CEILING.MATH.
• MROUND official ONLYOFFICE reference — a separate documented function; not an alias for CEILING.MATH.

• Docs/web documentation: The unversioned English ONLYOFFICE CEILING.MATH reference and current Spreadsheet Editor function catalogue list the formula. This establishes a documented function, not a successful calculation in any specific hosted Docs installation.
• ONLYOFFICE Docs release context: The Docs changelog lists version 10.0.0 with a release date of October 10, 2026. It does not, by itself, establish the first build that supported this particular rounding function, or prove that a given server has upgraded.
• ONLYOFFICE Desktop: Desktop Editors has a separate public release history. The available entries do not establish a first-support version for this function. No desktop binary was installed or used; treat Desktop support in historical builds as unverified.
• Regional formula settings: ONLYOFFICE Spreadsheet Editor Advanced Settings documents selectable formula language, region and number separators. The English/comma-based formulas above are the teaching notation, not a locale-independent guarantee. Function names and argument delimiters may require adaptation; there was no localized runtime test.
• Cross-program workbooks: A matching function name in Excel, LibreOffice, Google Sheets or an older OOXML workbook is not evidence that a particular ONLYOFFICE version executes it identically. Especially test negative-value rules, ties, zero significance and existing workbooks in the intended editor/edition.

• ROUND function guide
• ROUNDUP function guide
• ABS function guide

• CEILING.MATH function reference — syntax, purpose and explicit notes — checked 2026-10-13 UTC.
• Spreadsheet Editor: Insert functions — catalogue and function-entry procedure — checked 2026-10-13 UTC.
• Spreadsheet Editor: Advanced Settings — formula language and regional formats — checked 2026-10-13 UTC.
• ONLYOFFICE Docs changelog — release context — checked 2026-10-13 UTC.
• ONLYOFFICE DesktopEditors releases — separate platform history — checked 2026-10-13 UTC.

Verification limitations: Direct numerical outputs were independently calculated using an explicit mathematical model. Native Desktop/web execution, invalid-input runtime behavior, historical compatibility and localized formula parsing were not tested.