INT Function (OpenOffice Calc)
The INT function in OpenOffice Calc rounds a number down to the nearest integer. Learn syntax, behavior with negative numbers, examples, and best practices.
Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked
Availability and version history
- Introduced: Documented by Apache OpenOffice 4.1.16; original introduction not established.
- Availability: Supported in Apache OpenOffice 4.1.16, verified against its function registry. This identifies a supported release, not a final working version.
- Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
- Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.
INT rounds a number down to the nearest integer. “Down” means toward negative infinity: INT(-7.1) is -8. Use INT to put values into lower-bound intervals or to take whole days from an ordinary positive datetime serial.
Syntax and arguments
=INT(number)
number is one numeric value, reference or expression. There is no decimal-place parameter. INT returns a numeric integer; it does not convert a value into text or repair an identifier.
| Formula | Expected result |
|---|---|
=INT(7.9) |
7 |
=INT(7.1) |
7 |
=INT(-7.1) |
-8 |
=INT(-7.9) |
-8 |
=INT(-7) |
-7 |
=INT(0) |
0 |
For comparison, =TRUNC(-7.1) and =ROUNDDOWN(-7.1;0) both produce -7. Choose the rounding direction deliberately; truncation is not inherently safer than flooring.
Reproducible worksheet: ten-unit buckets
Put values -11, -1, 0, 9, 10 and 24 in A2:A7. In B2 enter =INT(A2/10)*10 and fill through B7. The expected lower boundaries are -20, -10, 0, 0, 10 and 20.
Each row belongs in the interval from its lower boundary inclusive to that boundary plus 10 exclusive. For A2=-11, the bucket is [-20,-10); for A3=-1, it is [-10,0). Truncating -1/10 toward zero would incorrectly place -1 in the [0,10) bucket.
In C2 enter =A2-B2 and fill down. Offsets inside the buckets are 9, 9, 0, 9, 0 and 4. This gives a useful consistency check for the chosen positive bucket width: each offset should be at least zero and less than 10.
Advanced applications
Whole groups. =INT(A1/12) gives 2 for 29 nonnegative items. If values may be signed and you want the integer part of division toward zero, use TRUNC(A1/12) or QUOTIENT instead.
Pagination. =INT((ROW()-1)/50)+1 labels worksheet rows 1–50 as page 1 and row 51 as page 2. If row 1 is a header and data begin in row 2, use =INT((ROW()-ROW($A$2))/50)+1 in the data rows. The offset matters.
Datetimes. Enter =DATE(2026;10;15)+TIME(13;30;0) in A1. =INT(A1) returns the serial for 15 October 2026 without the time fraction; format it as a date. =A1-INT(A1) returns 0.5625, the fraction representing 13:30. This is numeric date arithmetic, not text-date parsing.
Indexing. =INDEX(Data;INT(A1)) is useful only if Data is a defined range and the resulting row number is valid and positive. INT does not protect INDEX from zero, negative or out-of-range positions.
Other original patterns. =INT(Sheet1.A1) reads another sheet. =INT(RAND()*100) has the intended integer range 0–99 for RAND values in [0,1); RAND is volatile, so it is not a permanent identifier or a cryptographic random source.
Errors, boundaries and troubleshooting
- A value just below an integer can be visually rounded to that integer by its number format. Inspect more digits when the INT result surprises you.
- OpenOffice’s source uses an approximate-floor helper to account for floating-point noise. Do not use extremely near-integer examples as proof of bit-for-bit equivalence with another language’s floor function.
- Numeric-looking text should be converted deliberately.
ISNUMBER(A1)helps distinguish numeric data from imported text; do not assume text, empty cells and empty-string formulas behave identically. - Errors in the referenced expression are not ignored. A formula such as
=INT(A1/B1)must have a valid divisor before INT is relevant. - INT rounds stored values. Displaying no decimal places does not itself apply INT.
- FLOOR has its own significance and optional-mode rules in OpenOffice; it is not interchangeable with INT for every signed input.
Documentation and verification
The OpenOffice INT reference documents downward rounding. The 4.1.16 interpreter identifies the approximate-floor implementation. Ordinary examples were independently checked arithmetically. No new native execution, date-format GUI test or cross-product equivalence test is claimed; version history remains bounded by the availability evidence above.