Quick Navigation

ISEVEN Function

Excel 2007+

Summary

The Excel ISEVEN function determines if a given number is even by returning TRUE for even integers and FALSE for odd integers. It automatically truncates decimal portions and handles dates by converting them to their serial number equivalents.

Syntax

ISEVEN(number)

Parameters

Parameter	Type	Required	Description
number	`Number`	Yes	Numeric value to check. Non-integers are truncated; non-numeric values return #VALUE!

Using the ISEVEN Function

ISEVEN provides a simple way to check if numbers are even without using complex MOD formulas. It's particularly useful in conditional formatting, data validation, and logical tests where you need to distinguish between even and odd values.

Common ISEVEN Examples

Basic Even/Odd Tests

=ISEVEN(-1)

Tests negative number - returns FALSE (odd)"},{"title":"Decimal Truncation Example","code":"=ISEVEN(2.5)","description":"Truncates 2.5 to 2 - returns TRUE (even)"},{"title":"Zero Test","code":"=ISEVEN(0)","description":"Zero is considered even - returns TRUE"},{"title":"Date Testing","code":"=ISEVEN(DATE(2011,12,23))","description":"Dates convert to serial numbers (40900 is even) - returns TRUE"}]},

Conditional Formatting Even Rows

=ISEVEN(ROW())

Apply to row highlighting - TRUE for even-numbered rows

Frequently Asked Questions

Decimals are truncated to the nearest integer before testing. ISEVEN(3.9) becomes 3 (FALSE), ISEVEN(4.1) becomes 4 (TRUE).

Yes, negative even numbers return TRUE. ISEVEN(-2) = TRUE, ISEVEN(-1) = FALSE.

Dates convert to their serial numbers. ISEVEN checks if the serial number is even.

ISEVEN returns TRUE for even numbers, ISODD returns TRUE for odd numbers. They are complementary functions.

Common Errors and Solutions

#VALUE! Error

Cause: Input is non-numeric (text, blank, or error)

Solution: Ensure input contains valid numbers or use IFERROR to handle non-numeric cases

Unexpected results with decimals

Cause: Forgetting that decimals get truncated

Solution: Use INT() or ROUND() first if you need specific rounding behavior

Notes

Zero (0) is always considered even
Use MOD(number,2)=0 for equivalent results (but ISEVEN is cleaner)
Perfect for alternating row colors: =ISEVEN(ROW())
Combine with IF: =IF(ISEVEN(A1), "Even", "Odd")
Faster than MOD for large datasets

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2003 and earlier

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+