Exceljet

Quick, clean, and to the point

Excel ISEVEN Function

Excel ISEVEN function
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)
Arguments 
  • value - The numeric value to check.
Version 
Usage notes 

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.

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.