CEILING Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

Round quantities upward in fixed increments without understating required capacity. The documented English-language formula is CEILING(number, significance). All numerical outcomes below are independently derived worksheet expectations, with the official documentation cited for the exact signature and explicit error notes.

Round a value up to a specified multiple under the legacy CEILING sign rule. The chosen multiple must be large enough to cover the positive quantity. For positive inputs and increments, take the smallest integer multiple at least as large as the input.

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(number, significance)

Documentation-confirmed status: ONLYOFFICE’s CEILING reference identifies this name and argument order. Both named arguments are required; no default is documented.

Meaningful error/domain caution: The vendor explicitly documents #NUM! when number and significance have different signs. 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 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(B2,C2) 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 (the error demonstrations are the official documented sign-mismatch cases only):

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 function signature and any explicitly labelled vendor error text were checked against the official page; other platform-specific behaviour remains untested.

Order fulfilment: cases, labels and shipping cartons

Put B12 = 37 units ordered and C12 = 8 units per carton. In D12 enter =CEILING(B12,C12) to calculate an expected 40 units of carton capacity. In E12 enter =D12/C12 for an expected 5 cartons, rather than mistaking 40 for the carton count. A simpler count approach uses =CEILING(B12/C12,1) and expects 5.

For purchase quantities, =CEILING(12.01,0.5) expects 12.5 meters rather than 12.01 meters. The safety objective is to avoid under-ordering a discrete purchase unit. This is not a general-purpose nearest-value rounding formula.

Negative numbers and precision

A negative value with a positive significance is a documented #NUM! case for legacy CEILING. Do not silently assume the newer CEILING.MATH negative-direction rules apply to this function. Two negative arguments are not described in sufficient detail for this guide to certify a specific vendor result without a native calculation. For currency-like decimals, binary floating point may influence near-boundary comparisons; inspect input precision and apply business rules explicitly.

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.

Unlike CEILING.MATH, legacy CEILING requires a significance argument and documents a mismatched-sign error. The official text does not spell out every negative-input or zero-significance outcome, so those cases are flagged for actual editor tests.

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

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

• Docs/web documentation: The unversioned English ONLYOFFICE CEILING 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
• MOD function guide

• CEILING 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.