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

Return the greatest integer less than or equal to a number: the mathematical floor, including for negatives. Use the documented signature =INT(number). Numbers shown below are expected results from independent Decimal arithmetic and vendor documentation, not observed outputs from an installed ONLYOFFICE application.

Assign measurements to whole-number bins, count complete days or intervals when the quotient is nonnegative, and handle negative values without accidentally truncating toward zero. Its negative-number behaviour is the crucial difference from TRUNC.

For positives, INT(8.999) is 8; for negatives, INT(-8.999) is -9. This is not simply cutting off the fractional characters. ONLYOFFICE explicitly documents that negative inputs produce the first lower-or-equal integer, and Excel independently documents the same mathematical direction.

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

=INT(number)

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 INT 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 INT 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 INT; 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.

Bucketing a measurement into ten-unit intervals

To create groups of size 10, consider the quotient of a signed measurement. For an illustrative D2 = 47 and D3 = -47, enter:

=INT(D2/10)
=INT(D3/10)

Expected: 4 and -5. The positive value falls in the interval [40,50), and the negative value is in [-50,-40). This is useful for statistical buckets whose lower bound is inclusive. Do not use TRUNC here if negative buckets must be symmetric about zero: it would give -4 for the second value and misclassify the interval.

Full days from a duration in hours

Enter E2 = 49.75 hours. The completed 24-hour periods are:

=INT(E2/24)

Expected: 2. The remaining hours are =E2-24*INT(E2/24), with expected value 1.75. These are duration calculations, not a test of native spreadsheet date-time serial formatting, daylight-saving calculations or calendar arithmetic.

Fractional part from a positive measurement

=ROUND(A2-INT(A2),3)

With A2 = 12.341, expected 0.341. ROUND is a separately documented ONLYOFFICE function; the extra rounding step avoids displaying some binary floating-point artefacts. For negative values, x-INT(x) gives a nonnegative fractional offset from the floor (for -12.341, about 0.659), not a signed fractional part.

Enter =INT(-0.125) in an empty cell. The independently expected result is -1. Reason: The floor of a negative fraction lies below zero, not at zero. The actual output on your installed build must be recorded separately; it has not been observed in this research run.

• Negative inputs are not chopped toward zero: INT(-0.125) expects -1, not 0.
• There is no documented digits argument: INT(A2,2) is outside ONLYOFFICE’s published INT(number) syntax; use TRUNC or ROUNDDOWN for decimal-place control when appropriate.
• Signed grouping needs an explicit mathematical definition: flooring places -47/10 in bin -5, not bin -4.
• Use nonnegative quantities for “complete items” problems: INT on a negative ratio produces a lower integer than simple truncation.
• Formatting vs value: setting a cell to show no decimal places does not make it mathematically equal to INT of the stored number.
• Error codes and type coercion: official help does not enumerate the exact response to all text, blanks or overlarge magnitudes. Do not label guessed outcomes as tested ONLYOFFICE errors.
• Large values and floating-point proximity: values very close to whole integers should be tested in the target application before using as cutoffs in financial or scientific models.

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 INT 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.

Both ONLYOFFICE INT and Microsoft Excel INT explicitly describe rounding negative numbers toward the next lower integer. That is a documented agreement of stated behaviour; no full cross-platform formula execution occurred. INT versus TRUNC for negative values is the portable conceptual distinction to teach, not a claim of every build behaving identically.

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.

• TRUNC official reference — related operation; not a verified published Spreadsheet-Tutorials.com internal route.
• ROUNDDOWN official reference — related operation; not a verified published Spreadsheet-Tutorials.com internal route.
• ROUNDUP 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
• TRUNC 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.