What is the syntax for ISEVEN in Excel?

The syntax for ISEVEN is: =ISEVEN(number)

What are common errors with ISEVEN?

#VALUE! if not a number. Truncates decimals before testing

What is ISEVEN used for in Excel?

ISEVEN tests if a number is even (divisible by 2), returning TRUE or FALSE. Common uses: alternating row colors in conditional formatting, validating data entry, and creating patterns in formulas.

How do I use ISEVEN for alternating row formatting?

In conditional formatting, use =ISEVEN(ROW()) to format even rows differently. For odd rows, use =ISODD(ROW()). This creates zebra-striped tables that are easier to read.

Does ISEVEN work with decimals?

ISEVEN truncates decimals before testing. So ISEVEN(4.7) returns TRUE because it tests 4. ISEVEN(5.2) returns FALSE because it tests 5. For precise decimal testing, use MOD(number,2)=0.

Information

ISEVEN Function in Excel

Returns TRUE if the number is even.

Syntax

=ISEVEN(number)

Arguments

number (required): Number to test

Examples

=ISEVEN(4) - Test if 4 is even - Result: TRUE
=ISEVEN(5) - Test if 5 is even - Result: FALSE

Defensive formulas with ISEVEN

Use IS* functions inside IF to branch on blank, error, text, or number cells.
Prefer [IFERROR](/functions/iferror/) when you only need a fallback display value.
Error hub: [Fix formula errors](/guides/fix-excel-formula-errors/).

Common errors

#VALUE! if not a number
Truncates decimals before testing

Use cases

Conditional formatting
Alternating rows
Data validation

Frequently asked questions

What is ISEVEN used for in Excel? ISEVEN tests if a number is even (divisible by 2), returning TRUE or FALSE. Common uses: alternating row colors in conditional formatting, validating data entry, and creating patterns in formulas.
How do I use ISEVEN for alternating row formatting? In conditional formatting, use =ISEVEN(ROW()) to format even rows differently. For odd rows, use =ISODD(ROW()). This creates zebra-striped tables that are easier to read.
Does ISEVEN work with decimals? ISEVEN truncates decimals before testing. So ISEVEN(4.7) returns TRUE because it tests 4. ISEVEN(5.2) returns FALSE because it tests 5. For precise decimal testing, use MOD(number,2)=0.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.