ISEVEN in Collabora Office: Even Integers, Decimal Truncation and Count Validation

• Introduced: original Collabora release and launch date are not established by the sources reviewed.
• Availability: documented in Collabora Office 26.04 help, scoped to the desktop-help release.
• Platform scope: support in every online or mobile deployment is not inferred from desktop documentation.
• Checked: October 14, 2026. Complete function-specific documentation and independent controls; no native Collabora test was performed.

=ISEVEN(value)
=ISEVEN(48)
=ISEVEN(33)
=ISEVEN(0)

The last three controls have expected results TRUE, FALSE and TRUE. Zero is even under the documented example. A negative sign does not change the parity of the integer magnitude.

Examples use English function names and semicolons in multiargument helpers. All numerical expectations are independently calculated; no native Collabora run is claimed.

Enter these numeric values in A2:A11, then fill =ISEVEN(A2) down B2:B11:

Fractional values such as 0.9 and 2.9 can return TRUE even though the original inputs are not integers. There are seven TRUE flags in this ten-value fixture.

=ISEVEN(-2.1)
=ISEVEN(INT(-2.1))

Expected results are TRUE and FALSE. ISEVEN ignores the fractional part and sign, inspecting magnitude 2. INT rounds -2.1 downward to -3, whose magnitude is odd.

Ignoring fractional digits and rounding downward are not interchangeable operations for negative inputs.

For an already numeric quantity in A2:

=AND(A2>=0;A2=INT(A2);ISEVEN(A2))

For inputs -2, 0, 2, 2.5 and 4, expected flags are FALSE, TRUE, TRUE, FALSE and TRUE. The first condition rejects negatives, the second requires a whole number, and the third checks even parity.

ISEVEN alone returns TRUE for every one of these five inputs because each has an even integer magnitude. The additional requirements are what reject -2 and 2.5. Keep this control limited to numeric inputs; it does not claim AND skips unsafe expressions or validates every error and text type.

For nonnegative integer counts 0, 1, 2, 3, 4 and 5, ISEVEN returns TRUE, FALSE, TRUE, FALSE, TRUE and FALSE. If items must be grouped in pairs, use the explicit rule:

=IF(ISEVEN(D2);0;1)

The expected unpaired-item flags are 0, 1, 0, 1, 0 and 1. Their total is 3 across the six independent groups. This is not the number of unpaired items after pooling all groups: the pooled count 15 has only one remainder when grouped by two.

Whether groups may be pooled is part of the task definition, not something the parity function infers.

For the original ten numeric inputs, ISODD gives TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, TRUE and FALSE, the opposite parity flags under the same documented truncation rule.

That complement relationship is demonstrated only for these valid numeric inputs. It does not certify that both functions accept every text, blank, logical or erroneous argument in the same way.

Use ISNUMBER to inspect numeric type separately. A text label such as “2” may look like an even number, but its coercion is not established by this guide.

Very large values, exact binary boundaries, imported special types and every error code remain untested. Keep parity, integer validation and nonnegative-domain rules distinct, and use ordinary exact integer controls before applying the result to a real report.

• Collabora Office 26.04: ISEVEN.
• Editorial testing standards.

The complete function section was reviewed. Worked controls are independently checked expectations; native execution, broader client support and unlisted edge cases remain unverified.