ISEVEN Function
Checks whether a number is even.
Category
Information
Available in
All versions, Microsoft 365
Returns
TRUE or FALSE
Want to practice ISEVEN in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
ISEVEN returns TRUE for even numbers and FALSE for odd ones. Decimals are cut off first, so 4.9 counts as 4.
Typical uses: alternating rows, splitting items into two groups, or checking check-digits.
Syntax
=ISEVEN(number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The number to test. Decimals are truncated; text that isn't a number gives #VALUE!. |
Examples
Example 1 — Even or odd?
Decimals are dropped before the test, and negative numbers work too.
B2fx=ISEVEN(A2)
| A | B | |
|---|---|---|
| 1 | Number | Even? |
| 2 | 14 | TRUE |
| 3 | 7 | FALSE |
| 4 | 4.9 | TRUE |
| 5 | -6 | TRUE |
| 6 | 0 | TRUE |
=ISEVEN(A2) Explain
Example 2 — Split a team into two shifts
Alternate people between the early and late shift using their row number.
B2fx=IF(ISEVEN(ROW()),"Early","Late")
| A | B | |
|---|---|---|
| 1 | Name | Shift |
| 2 | Amara | Early |
| 3 | Ben | Late |
| 4 | Chloe | Early |
| 5 | Dev | Late |
=IF(ISEVEN(ROW()),"Early","Late") Explain
Common mistakes
- A blank cell returns TRUE. Blank counts as 0, which is even. Guard with ISBLANK if that matters.
Notes
- Shade every other row with Conditional Formatting: =ISEVEN(ROW()).
- Related functions: ISODD, MOD, ROW.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.