Round a quantity away from zero to a chosen decimal place, even when the dropped digits are small. Use the documented signature =ROUNDUP(number, num_digits). Numbers shown below are expected results from independent Decimal arithmetic and vendor documentation, not observed outputs from an installed ONLYOFFICE application.

Plan whole cartons for positive quantities, round a positive quote conservatively for a non-regulated estimate, or group magnitudes by tens or hundreds. This is not the same as mathematical ceiling for negative numbers.

For positive inputs, round upward in magnitude; for negative inputs, the Excel-style expectation is farther from zero. Example: -3.141 at two decimals becomes -3.15; it is not -3.14. ONLYOFFICE names this function and documents its signature but its short help article does not explicitly spell out negative-number and negative-digit cases; the listed outputs are independently calculated expected checks, still needing native testing.

ONLYOFFICE ROUNDUP function reference establishes the function’s published signature and basic purpose. The vendor’s function-selection guide describes entering formulas via the Formula tab or manually after an equals sign.

=ROUNDUP(number, num_digits)

The function name is typed literally, but number and num_digits are placeholders for actual arguments, references or expressions. Square brackets in the documentation signature denote an optional parameter; they are not literal characters to type. In this guide, every explicit num_digits is an integer so a fractional-precision coercion rule need not be assumed.

Precision guide: for two-argument rounding/truncation, num_digits = 2 denotes hundredths, 1 tenths, 0 whole units, and -2 hundreds (the negative-digit cases are documented as test expectations requiring native confirmation). For INT there is only one documented argument; no digits parameter exists.

• Primary product scope: ONLYOFFICE Docs Spreadsheet Editor, English unversioned current function help and Insert Functions index, checked 2026-10-11 UTC. The help article documents a function, not a first-available version, so first_supported_version = UNKNOWN.
• Server/web edition: documented at the official help level; not executed in a known installed Docs server build. The Docs changelog contains a dated 9.4.0 entry (2026-05-20), but that does not prove this particular function was introduced then.
• Desktop Editors (Windows/macOS/Linux): the Formula tab guide shows a desktop and online interface, and the separate Desktop changelog records Desktop 9.4.0 (2026-05-19). No version-specific ROUNDUP execution was run on a desktop build, and function compatibility is not inferred from the release number alone.
• Mobile and integrations: availability and evaluation results across particular builds have not been validated; a Docs web documentation page is not a complete mobile or edition/version matrix.
• English examples and separators: all formulas below begin with = and use comma argument separators, as illustrated in the English insert function guide. Advanced Settings permits selecting the Formula Language and region. Verify local function names, separators and decimal conventions on the target installation; copying English examples unchanged is not guaranteed to work in every locale.

Create an empty sheet. Enter the numbers below in column A as numeric values, not quoted text. The leading minus sign is part of the negative input. These are intentionally simple decimal inputs so that a calculation can be independently checked without a screenshot.

Step-by-step use

1. In A1 type Input. Enter the ten numeric values from the table in A2:A11. In B1 type ROUNDUP expected check.
2. Copy each formula from the following table into the indicated cell in column B. Alternatively, insert the function through the Formula tab → Function search and choose ROUNDUP; check the argument order displayed.
3. Compare each value with its expected result below, checking whether the negative sign and num_digits are correct. Results are not screenshots or claims of a native app run.
4. Change one original input (for example, change A2 to 12.300) and note whether the corresponding result changes. Restore A2 = 12.341 before checking other formulas.
5. If a result differs, record the version, product edition, formula language, number format, actual formula and displayed result. Do not silently replace the independently calculated result with a guessed application output.

Worked formulas and expected results

What to notice: Each row demonstrates a different sign, precision or boundary case. A table cell showing 12.3 numerically does not have to display a trailing zero such as 12.30 unless its cell number format requests it. Displayed decimals and the number used by a formula are separate concepts.

Capacity planning: do not under-order cartons

Create a separate small table with D2 = 53 items and E2 = 12 items per carton. In F2, enter:

=ROUNDUP(D2/E2,0)

=IF(E2>0,ROUNDUP(D2/E2,0),"Check capacity")

With E2 = 12, expected 5. With E2 = 0, the intended result is Check capacity. This guards one known input problem; it does not certify error behaviour in every edition. Do not use a floating-point ratio when a validated integer-division process is mandated by inventory software.

Group an estimate into hundreds

=ROUNDUP(2125,-2)

Expected: 2200. This chooses the next hundred in magnitude for a positive amount; negative-digit behaviour needs version-specific confirmation. This is a planning choice, not a general accounting, tax or legal rounding rule.

Make sure 0.01 is enough precision

=ROUNDUP(17.231,2)

Expected: 17.24. If this is a selling price, explain to readers that mandatory tax and invoice rules may require a different rounding method. Changing the displayed number format to two decimals is not equivalent to replacing the underlying value with a rounded number.

Enter =ROUNDUP(-8.999,1) in an empty cell. The independently expected result is -9. Reason: Rounding negative numbers away from zero has a direction that is easy to overlook. The actual output on your installed build must be recorded separately; it has not been observed in this research run.

• Confusing away-from-zero with positive infinity: ROUNDUP(-3.141,2) has the Excel-compatible expectation -3.15, not -3.14. This sign-sensitive case should be verified natively before relying on it for a production workbook.
• Missing the required argument: the official help requires num_digits, even to round to an integer (0); ROUNDUP(A2) is not the documented signature.
• Incorrect negative digits: -2 means hundreds-place precision, not “two decimal places of output.”
• Already exact: an integer such as 15 rounded to two decimal places stays numerically 15; a cell may display 15.00 because of formatting.
• Tiny nonzero values: away-from-zero rounding may create a larger-magnitude result than visually expected (for example positive 0.125 at one decimal → 0.2).
• Numbers stored as text or invalid argument types: the function page does not enumerate all error codes or coercion rules; do not promise that a text value will be converted in every version.
• Floating-point representation: decimal fractions can have finite-display and binary-storage differences. Recheck boundary cases in the target native editor.

Troubleshooting checklist

1. A formula appears verbatim instead of calculating: ensure the cell contains a formula beginning with = rather than a quoted or text-formatted string; use the documented Formula-tab insertion method.
2. An unrecognized function name or argument warning: search for ROUNDUP in the actual installed version’s Insert Function dialog. Verify the formula language and spelling; do not assume the web reference’s function name is the local display name.
3. An unexpected negative answer: compare the sign-sensitive explanation and the row for A3, A5, A7, or A9. Decide whether your business rule means toward zero, away from zero, or toward negative infinity.
4. An unexpected precision: check whether the precision was 2, 0 or -2, whether the formula selected the intended input cell, and whether the cell’s number format is hiding digits.
5. Errors from blank/text values: first reproduce with a literal numeric argument. Only then test the imported value; the published short function reference does not establish all error codes or implicit coercion rules. Do not label an unobserved outcome as an ONLYOFFICE bug.
6. Excel import gives a different value: save a minimal workbook with one example, record both application versions, platform and language, and ask for a native side-by-side result. Matching English signatures alone are not sufficient evidence of identical evaluation.

Microsoft Excel explicitly describes ROUNDUP as rounding away from zero, with num_digits controlling digits left or right of the decimal point. ONLYOFFICE documents the same English signature, but the two vendors’ help pages are not a cross-version proof of identical numerical edge cases. Google Sheets and other editors should be checked on the particular build and locale rather than assumed equivalent. Microsoft Excel ROUNDUP documentation.

Specific documented distinction: INT is mathematically a floor, while TRUNC removes digits toward zero; ROUNDUP and ROUNDDOWN select directional rounding at a requested place. Although the names appear in other spreadsheet products, no equivalent names, arguments, conversions or error results are assumed for a particular Google Sheets, LibreOffice, Apple Numbers or localized installation without separate current evidence.

• ROUNDDOWN official reference — related operation; not a verified published Spreadsheet-Tutorials.com internal route.
• INT official reference — related operation; not a verified published Spreadsheet-Tutorials.com internal route.
• TRUNC official reference — related operation; not a verified published Spreadsheet-Tutorials.com internal route.
• ROUND official reference — related operation; not a verified published Spreadsheet-Tutorials.com internal route.

• ONLYOFFICE Spreadsheet Editor — function documentation
• vendor’s function-selection guide
• Docs changelog
• Formula tab guide
• Desktop changelog
• Advanced Settings
• ROUNDDOWN official 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.