ISEVEN_ADD Function (LibreOffice Calc)

• Introduced: First release not established; documented by LibreOffice 3.3.
• Supported in: Documented in LibreOffice 26.8 Help and registered in 26.8.1.1. No retirement is established.
• Scope: Desktop Calc, English compatibility function name and semicolon-separated formulas. A suffix does not by itself mean deprecated or retired.
• Checked: October 14, 2026. Eight reference calculations and the function-specific documentation were checked. The integer callback was inspected. No native execution is claimed.

ISEVEN_ADD returns numeric 1 for an even integer and numeric 0 for an odd integer through the Analysis add-in interface. It is distinct from the core ISEVEN function. The implementation tests the low binary bit of its signed integer argument. Function-specific Help.

LibreOffice’s documentation describes _ADD names as compatibility variants associated with Excel 2003 behavior and recommends the unsuffixed functions for standards-oriented results. Keep the exact original function name when evaluating an imported workbook.

=ISEVEN_ADD(Number)

• Number: integer to classify.

Exactly one argument is declared. The add-in receives a signed 32-bit integer and returns a signed 32-bit integer. Use ordinary integers when reproducing the inspected integer contract; fractional and out-of-range conversion are not covered here.

These references use integer parity and the inspected integer callback. The results are exact for the small integers shown.

The integer examples 0, 2, −2 and 100 return 1. Inputs 1, 7, −1 and −7 return 0. Zero is even because it is divisible by 2 with no remainder. A negative sign does not change whether an integer is even.

For a sequence of integer identifiers, numeric 1/0 results can be used as indicators. Adding the indicators counts even identifiers, but the formula does not validate whether the identifiers were intentionally integers before they reached the add-in interface.

For every listed integer k, the two add-in parity functions satisfy ISEVEN_ADD(k)+ISODD_ADD(k)=1. This follows independently from integer parity: exactly one of even and odd applies. It is not evidence that arbitrary text or fractional values belong to the same contract.

The source expression tests nVal & 1 and returns an integer literal. The integer return type establishes a numeric indicator in the inspected implementation. No saved native LibreOffice result is claimed for this table. Formatting a numeric one as a logical value does not change the underlying function identity.

The visible integer interface does not itself document every spreadsheet-to-integer conversion rule. The reference rows deliberately use small exact integers, including both signs. Fractions, empty cells, text, errors and values outside the signed 32-bit range were not executed.

If replacing an imported compatibility formula with core ISEVEN, verify the core function’s conversion and result conventions separately. A matching result for 2 is not a general compatibility proof. Keep the add-in suffix when identifying the original formula in an audit or migration.

ISEVEN, ISODD, MOD.

• Function-specific Help and compatibility note
• Versioned Analysis add-in registration
• Complete integer parity callback

The references establish the documented ordinary model and the source’s signed integer input/return contract. Native execution, exceptional-input behavior and cross-product equivalence remain unverified.