Related Functions:

The ISEVEN function tests if an initial supplied number (or expression) evaluates to an even number, and if so, returns TRUE; Otherwise, the function returns FALSE.

Syntax

=ISEVEN(number)

Arguments

Argument Description
number The number argument can be a simple number, a formula that returns a numeric value, or a reference to a cell that contains a number

Examples

  A B C D
1   Formula Result Notes
2   =ISEVEN(0) TRUE The Iseven function returns True for a zero value
3   =ISEVEN(1) FALSE  
4 2 =ISEVEN(A4) TRUE  
5 =20/4 =ISEVEN(A5) FALSE  
6 10 =ISEVEN(A6) TRUE  
7   =ISEVEN(A7) TRUE An empty cell evaluates to zero and so the ISEVEN function returns True

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied number argument is not a numeric value