ISODD & ISEVEN Number Parity Formulas
Learn how to test integer parity in Excel with ISODD and ISEVEN. Create alternating zebra stripe formats, split dual-shift rosters, and avoid decimal truncation traps.
Logistics dispatchers and warehouse managers frequently divide delivery routes into alternating schedules. For example, even-numbered delivery routes might serve the North Hub while odd-numbered routes head to the South Hub. In financial reporting, analysts often format tables with alternating row shading (zebra striping) to improve readability.
Instead of writing mathematical modulo formulas like =MOD(A2, 2) = 0, Excel provides two dedicated parity test formulas: ISODD and ISEVEN.
Quick Comparison: ISODD vs ISEVEN
| Formula | When It Returns TRUE | Result on 0 | Common Practical Application |
|---|---|---|---|
ISEVEN(number) |
When the number is evenly divisible by 2 | TRUE (0 is treated as even) | Shading even rows in conditional formatting: =ISEVEN(ROW()). |
ISODD(number) |
When the number has a remainder of 1 when divided by 2 | FALSE | Assigning alternating weekend on-call shifts and batch splits. |
Deep Technical Mechanics
1. The Decimal Truncation Rule
If you pass a decimal number into ISODD or ISEVEN, Excel does not round the number. Instead, it truncates the decimal portion completely:
=ISEVEN(2.9)truncates to2and returnsTRUE.=ISODD(3.1)truncates to3and returnsTRUE.
Always keep this in mind when auditing floating point measurements or currency amounts.
2. Negative Numbers and Zero
Negative integers preserve their parity rules: -4 is even, and -5 is odd. Zero is strictly treated as an even number.
3. Zebra Striping Tables with ROW()
You can create alternating shaded rows without converting your range into an official Excel Table by using =ISEVEN(ROW()) as your conditional formatting rule.
Hands-on Practice Playground
Use the dispatch route table below to test parity for delivery allocations. Follow each objective to complete the exercise.
In cell C2, check if route number B2 is even using ISEVEN.
In cell C2, determine whether route number B2 is an even number using the ISEVEN formula.
In cell D2, test if route number B2 is odd using ISODD.
In cell D2, test whether route number B2 is an odd number using the ISODD formula.
In cell C3, check if route number 27 in B3 is even.
In cell C3, evaluate whether shipment SHP-102 route number B3 is even using the ISEVEN formula.
Share This Lesson
Spread the word with your peers and challenge your friends