ROUNDDOWN Function in ONLYOFFICE Spreadsheet Editor: Syntax, Examples and Limits

Discard unwanted digits toward zero rather than rounding to the mathematically nearest value. Use the documented signature =ROUNDDOWN(number, num_digits). Numbers shown below are expected results from independent Decimal arithmetic and vendor documentation, not observed outputs from an installed ONLYOFFICE application.

Count fully filled containers, intentionally cap a non-regulated estimate, or keep only a specified number of decimal places without increasing a positive number. For negative values, “down” in this function name is not the same as flooring toward negative infinity.

The conventional Excel-compatible interpretation is to round toward zero. Thus positive 8.999 at zero digits gives 8, and negative -8.999 gives -8 rather than -9. ONLYOFFICE provides the documented name and signature, but its short function help does not enumerate the exact negative-digit or numeric coercion edge cases.

ONLYOFFICE ROUNDDOWN 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.

=ROUNDDOWN(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 ROUNDDOWN 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 ROUNDDOWN 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 ROUNDDOWN; 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.

Count complete packs, not the packs needed for shipment

Enter D2 = 53 items and E2 = 12 items per pack. The number of completely filled packs is:

=ROUNDDOWN(D2/E2,0)

Expected: 4 complete packs, because 4 × 12 = 48 items. To plan enough packs to ship all 53, the business question changes, and =ROUNDUP(D2/E2,0) has expected answer 5. Mixing these goals creates under-shipping errors.

Separate full groups and leftovers

=ROUNDDOWN(53/12,0)
=MOD(53,12)

Deliberately discard a measurement’s low-precision digits

=ROUNDDOWN(41.896,1)

Expected: 41.8. The discarded digits do not get rounded up. This may be appropriate for an instructional approximation but does not establish measurement uncertainty, professional reporting precision or an approved tax treatment.

Enter =ROUNDDOWN(-8.999,1) in an empty cell. The independently expected result is -8.9. Reason: Unlike INT, toward-zero truncation brings this negative value closer to zero. The actual output on your installed build must be recorded separately; it has not been observed in this research run.

• ROUNDDOWN is not INT for negative values: ROUNDDOWN(-8.999,0) expects -8, whereas INT(-8.999) expects -9.
• ROUNDDOWN is not a shipping-quantity calculator unless you want complete groups: for the number of groups needed, use ROUNDUP on a nonnegative ratio.
• Second argument is required: the official ROUNDDOWN(number, num_digits) article does not describe a default. Always supply 0 explicitly to get whole units.
• Negative num_digits changes the place value: =ROUNDDOWN(1492.6,-2) expects 1400, not 1492.60.
• Display formatting is independent: changing a cell to show two decimal places can hide precision without changing the value; ROUNDDOWN is a calculation.
• Bad source types and fractional digit counts: official short help does not specify all parsing, coercion or fractional num_digits behaviours; investigate directly instead of assigning an unsupported error code.
• Decimal boundary inputs: binary representation of decimal values can affect boundary expectations; use deliberate test cases and record actual editor build.

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 ROUNDDOWN 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 defines ROUNDDOWN as rounding toward zero, including negative inputs and negative num_digits. ONLYOFFICE lists the same English signature but does not publish an equally comprehensive edge-case table in the linked short reference. Treat this as a well-sourced Excel-to-ONLYOFFICE test expectation, not an observed edition-to-edition guarantee. Excel ROUNDDOWN.

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.

• ROUNDUP 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.
• MOD 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
• ROUNDUP 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.