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

ArgumentRequired?What it does
numberYesThe 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)
AB
1NumberEven?
214TRUE
37FALSE
44.9TRUE
5-6TRUE
60TRUE
=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")
AB
1NameShift
2AmaraEarly
3BenLate
4ChloeEarly
5DevLate
=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.
Kyle Stott

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.