PlanMaker ISEVEN: Check parity without accepting fractional quantities
ISEVEN returns a logical result after checking whether the integer part of a number is even. PlanMaker explicitly removes decimal places first. Consequently, a TRUE result does not prove that the original quantity was a whole number.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
ISEVEN returns a logical result after checking whether the integer part of a number is even. PlanMaker explicitly removes decimal places first. Consequently, a TRUE result does not prove that the original quantity was a whole number.
Availability and verification
The PlanMaker 2026 reference, 2024 reference and 2021 reference were retrieved and compared on October 15, 2026. They document this function’s core operation. Documented by 2021 is not an original introduction date; the first introduction and any last-working-version endpoint remain unverified. The 2026/NX manual family does not establish per-build availability in FreeOffice, mobile clients or every operating system.
The examples below are vendor-supported controls and independently modeled expectations. No native PlanMaker execution, screenshot capture or workbook interchange test was performed. Keep the distinction between documentation support and observed application behavior when applying the guide to an installed version.
Syntax and argument
=ISEVEN(Number)
There is one required argument and no documented optional default. Number is the numeric value whose parity is tested. The documented decimal-removal rule is explained below. The formulas use English function names. The one-argument call needs no list separator; nested helper formulas below use commas, which may need adjustment for the installed locale.
Exact fraction rule and vendor controls
SoftMaker gives ISEVEN(2) and ISEVEN(2.75) as TRUE, while ISEVEN(3) and ISEVEN(3.75) are FALSE. This is removal of decimal places, not rounding to the nearest integer. Keep the original input alongside the result if fractions are meaningful.
Create EvenControls with Number, Even and Odd in A1:C1. Fill B2 =ISEVEN(A2) and C2 =ISODD(A2) through row 11 using this dataset:
| Row | A | Expected B | Expected C |
|---|---|---|---|
| 2 | 0 | TRUE | FALSE |
| 3 | 1 | FALSE | TRUE |
| 4 | 2 | TRUE | FALSE |
| 5 | 2.75 | TRUE | FALSE |
| 6 | 3 | FALSE | TRUE |
| 7 | 3.75 | FALSE | TRUE |
| 8 | 8 | TRUE | FALSE |
| 9 | 9 | FALSE | TRUE |
| 10 | -2 | TRUE | FALSE |
| 11 | -3 | FALSE | TRUE |
For these numeric controls the two parity flags are complementary. Negative integers have the same parity as their positive counterparts. Negative fractional inputs, numeric text, Booleans, blank cells and very large numbers are outside this fixture; their exact target-build handling has not been observed.
Change A5 from 2.75 to 3.25 in a copy. B5 changes to FALSE and C5 TRUE. Neither original nor replacement is a whole quantity, which is why parity alone cannot be a whole-number validation rule.
Advanced: whole units packed in pairs
Create PairPacking with Quantity, Whole, Even and Action in A1:D1. Enter 0,2,3,4.5,8,9.75 in A2:A7. Fill B2 =A2=TRUNC(A2), C2 =ISEVEN(A2) and D2 below through row 7:
=IF(B2,IF(C2,"Complete pairs","One unpaired unit"),"Review fraction")
Expected B is TRUE, TRUE, TRUE, FALSE, TRUE, FALSE. Expected C is TRUE, TRUE, FALSE, TRUE, TRUE, FALSE. Expected D is Complete pairs, Complete pairs, One unpaired unit, Review fraction, Complete pairs, Review fraction. The sample quantities are nonnegative; if your source permits negatives, validate that sign rule separately before interpreting an item count.
The 4.5 row is the critical control. Its even flag is TRUE because the retained integer part is 4, yet the action is Review fraction. A rule that accepts every even result would incorrectly pass this fractional quantity.
On a copy, change A5 from 4.5 to 4. B5 becomes TRUE, C5 stays TRUE, and D5 becomes Complete pairs. Changing the odd whole quantity 3 to 4 changes the action from One unpaired unit to Complete pairs. These are different repairs and should be recorded separately.
Troubleshooting and limits
Do not confuse ISEVEN with EVEN: the former tests parity, while a rounding function changes a value. An even flag is not a rounded quantity and should not replace the source number.
The reference states decimal removal but does not supply a maximum reliable integer, a complete coercion table or every error token. At magnitudes where input precision cannot distinguish neighboring integers, parity requires particular care; no such boundary is asserted here. Test the actual build and input representation before relying on large identifiers.
ISODD checks the complementary parity. TRUNC exposes the retained integer part for the independent whole-number check. The nested IF example is a contract-based worksheet specification, not a native PlanMaker execution.
Verification checklist for your installation
Record the PlanMaker version/build, edition, platform, language and workbook format. Recreate the original dataset, inspect the actual formulas and then apply the specified one-cell changes on a copy. Compare the original and changed outputs, not only a screenshot of the final values. Save/reopen and cross-product import results remain separate tests; neither was performed for this guide.