ISEVEN Function in Excel: Is the Number Even?

⏱ 1 min readUpdated 28 September 2026

InformationLevel: BeginnerAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Example 2
  5. Related functions

ISEVEN returns TRUE for even numbers; ISODD for odd ones. Decimals are truncated first.

Syntax

=ISEVEN(number)
Argument What it means
number A number.

Examples

Example 1

=ISEVEN(ROW())

Shade every other row.

Example 2

=IF(ISODD(MID(A2,17,1)), "Male", "Female")

Example of a code where the odd/even digit carries meaning.

ISODD · MOD

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZFACTDOUBLE Function in Excel: Double FactorialExcel Functions A–ZMID Function in Excel: Extract Text From the MiddleExcel Functions A–ZINDIRECT Function in Excel: Build a Reference From Text
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong