Summary

The Excel ISEVEN function returns TRUE when a value is an even number, and FALSE when a value is an odd number. ISEVEN will return the #VALUE error if a value is not numeric.

Purpose 

Test if a value is even

Return value 

A logical value (TRUE or FALSE)

Syntax

=ISEVEN(value)
  • value - The numeric value to check.

How to use 

The ISEVEN function tests for even numbers. ISEVEN takes one argument, value, which should be a numeric value or a cell reference. When value is an even number, ISEVEN returns TRUE. When value is an odd number, ISEVEN returns FALSE. If value is not numeric, ISEVEN will return the #VALUE error. Only the integer portion of value is evaluated, decimal values are truncated.

Examples

The ISEVEN function returns TRUE or FALSE:

=ISEVEN(4) // returns TRUE
=ISEVEN(3) // returns FALSE
=ISEVEN(0) // returns TRUE

If cell A1 contains 11, the formula below returns FALSE:

=ISEVEN(A1) //returns FALSE

Only the integer portion of value is tested. If value is a decimal number, the decimal portion is truncated:

=ISEVEN(4.1) // returns TRUE
=ISEVEN(0.33) // returns TRUE
=ISEVEN(7.4) // returns FALSE

Notes

  • If value is not numeric, ISEVEN will return the #VALUE error.
  • Only the integer portion of value is tested, decimal values are truncated.
  • Use the ISODD function to test for odd numbers.
Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.