ISO.CEILING Function in ONLYOFFICE Spreadsheet Editor: Syntax and Worked Examples

Round any signed value to the next higher specified multiple using the separately documented ISO.CEILING function. ONLYOFFICE’s official help article documents the English formula syntax below. Numerical results shown here are mathematical expectations, not observed software output.

Set an upper bound on a positive or negative quantity using consistent increments. The ISO label is part of the function name; it is not an ISO date calculation and does not mean that setting a worksheet locale changes the mathematics.

ISO.CEILING and CEILING.PRECISE are separate official catalogue entries with mathematically equivalent documented descriptions. Treat them as related function names, not two slugs for the same function, and do not claim historical interoperability without target-build testing. Unlike ROUND(number,num_digits), which uses decimal places, ISO.CEILING uses a multiple. For a step of 0.25, possible results lie on a quarter-unit grid; for a step of 8, possible results lie on an eight-unit grid. Do not confuse an increment with the number of decimal places displayed in the spreadsheet.

Direction rule: toward positive infinity (a mathematical upper bound). The rule is documented by ONLYOFFICE’s ISO.CEILING help; the example results are independently calculated for positive step sizes.

=ISO.CEILING(number, [significance])

Square brackets in the help page denote optional arguments; do not type literal square brackets in the formula. For ordinary examples, use explicit numeric cells and a positive significance. The help article does not establish a complete type-coercion policy for blank/text/booleans or all negative significance values.

Zero-significance note: Official reference explicitly says significance 0 returns 0. The help article explicitly says significance = 0 returns 0, even though an “increment of zero” is not mathematically useful as a rounding step. Model this as an officially documented exception, not a consequence of division by zero.

Notation: Examples use the English formula language and comma argument separators shown in the official Insert Function instructions. Regional formula language and input settings must be checked in the editor actually used.

1. Start a blank ONLYOFFICE Spreadsheet Editor sheet. In A1 type Scenario, B1 type Number, C1 type Step, and D1 type Result. Keep the scenario text separate from numeric cells.
2. Copy the scenario, number and step from each row of the table into the specified cells. Do not insert a mode column for this two-argument function.
3. In the result column, type the exact row formula shown below, then copy down only if the cell references follow the intended row. The vendor describes the Formula tab or Shift+F3 for inserting a function as an alternative to typing.
4. Check the displayed value against independent expectation. If the editor reports an error, check the function name, punctuation, numeric values, argument separator, and the specific Desktop/web release first.
5. Keep a second untouched input column if you are testing imported workbooks. Rounding should produce a new result, not silently replace source measurements or prices.

How the numbers were derived: Divide by a positive increment, take the mathematical ceiling of the quotient, and multiply by the increment. A negative number becoming numerically larger is consistent with an upper bound. For significance zero, use ONLYOFFICE’s explicitly documented zero output rather than division. This is not a screenshot, native engine test, or locale validation. A differently configured editor could show a different display precision even when the underlying mathematical number matches.

Enter each formula in an empty test cell. The expected outputs are independently calculated using decimal arithmetic except any zero-significance example, whose expectation comes directly from the official article. The table avoids undocumented negative significance and nonnumeric coercion.

These examples illustrate the documented input pattern, not a claim about all historical spreadsheet engines. If the intended installation rejects a formula, collect its product/version and an actual test result before extending compatibility claims.

Batch size target

B12 = 37 required items and C12 = 8 items per batch. Enter =ISO.CEILING(B12,C12) in an empty result cell. The independently expected output is 40. Reserve room for a fifth batch. For integer batch count use =ISO.CEILING(B12/C12) and expect 5.

Signed plan variance

B13 = −19.2 signed units and C13 = 5 units per step. The formula =ISO.CEILING(B13,C13) has an independently expected output of -15. Upper means closer to zero for negative values; it does not mean a greater absolute amount.

Avoid rounding the wrong unit

If a worksheet holds individual items but a team wants full cartons, decide whether to round items to carton-sized increments or round carton counts to whole numbers. For example, rounding 37 items to a multiple of 8 produces a number of items; rounding 37/8 to a whole number produces a number of cartons. The two numeric outputs use different units. Label your result column accordingly.

Sign, zero and policy audit

A negative number is not automatically an error. ISO.CEILING and CEILING.PRECISE are separate official catalogue entries with mathematically equivalent documented descriptions. Treat them as related function names, not two slugs for the same function, and do not claim historical interoperability without target-build testing. Document the increment alongside each formula so another editor can reproduce the rule months later. Do not silently swap the names of similar functions based on familiarity with Excel, LibreOffice or Sheets; the ONLYOFFICE help page is the primary documented authority here.

Error-code evidence boundary: The official ISO.CEILING article lists the signature and descriptive rules but does not give a complete table of #VALUE!, #NUM!, #DIV/0! or all zero/text/negative-step behaviour. This guide intentionally does not assign an unverified error message to those cases. If the help article explicitly defines a special numeric result (such as significance zero), that special case is documented above.

The official help centre lists ISO.CEILING and CEILING.PRECISE as distinct formula names with the same documented two-argument pattern. Existing formula text, workbook compatibility, and historical release support should be preserved and checked before replacing either name.

• CEILING.PRECISE — official function reference — separately documented function name; compare the full argument list before substituting.
• CEILING.MATH — official function reference — separately documented function name; compare the full argument list before substituting.
• CEILING — official function reference — separately documented function name; compare the full argument list before substituting.
• FLOOR.PRECISE — official function reference — separately documented function name; compare the full argument list before substituting.

• Current documentation: The ONLYOFFICE ISO.CEILING function article establishes current unversioned Docs help coverage and the written syntax; it does not prove a particular hosted web deployment or installed Desktop release executes it.
• Docs / web release history: The separately maintained ONLYOFFICE Docs changelog lists Docs 10.0.0, released October 10, 2026. The reviewed release notice does not identify when this specific rounding function first became executable. A self-hosted instance may be on another version.
• Desktop release history: The ONLYOFFICE Desktop Editors changelog separately lists Desktop 9.4.0 dated May 19, 2026 and Desktop 9.3.0 dated February 25, 2026. The reviewed entries do not establish ISO.CEILING’s first supported Desktop version. No desktop binary was run.
• Regional settings and formula language: The Spreadsheet Editor Advanced Settings guide describes the selected formula language and regional display separators. English names with comma separators are the documented notation here; do not assume localizations of punctuation, arguments or function names without a targeted runtime check.
• Interchange with other programs: An XLSX file that contains a function of the same name or mathematical behaviour in Excel, Google Sheets or LibreOffice is not ONLYOFFICE execution evidence. Verify sign, zero significance, imported formula retention, precision and compatibility separately in the intended ONLYOFFICE Desktop and Docs versions.
• Historically documented vs currently executable: The current unversioned help page does not expose a first-support release matrix. Mark older/version-specific behaviour not verified rather than inventing a version cutoff.

• CEILING.PRECISE
• CEILING.MATH
• CEILING

1. ISO.CEILING: official purpose, syntax, argument order and documented special-case rules — checked 2026-10-13 UTC. Direct source for the first four sections, the documented default and the documented special-case cautions.
2. Spreadsheet Editor: Insert functions — checked 2026-10-13 UTC. Direct source for the current catalogue entry and procedure for entering function arguments.
3. Spreadsheet Editor: Advanced Settings — checked 2026-10-13 UTC. Direct source for localization and regional-number settings; not evidence that translated ISO.CEILING formulas were tested.
4. ONLYOFFICE Docs changelog — checked 2026-10-13 UTC. Documents release-context dates, not the first availability of this function.
5. ONLYOFFICE Desktop Editors changelog — checked 2026-10-13 UTC. Documents a separate Desktop version track, not successful execution of this formula.

Verification limitations: Numerical examples were independently calculated. Native ONLYOFFICE execution, localized formula entry, a complete error matrix and historical-version compatibility were not tested.