The Excel ISEVEN Function

Related Functions:
ISNUMBER
ISODD

Basic Description

The Excel 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.

The syntax of the function is:

ISEVEN( number )

Where the supplied 'number' argument can be a simple number, a formula that returns a numeric value, or a reference to a cell that contains a number.


Iseven Function Examples

Several examples of the Excel Iseven function are shown in the spreadsheet below. The spreadsheet on the left shows the formulas used and the spreadsheet on the right shows the results:

 Formulas:
  A B
1 =ISEVEN( 0 )  
2 =ISEVEN( 1 )  
3 =ISEVEN( 2 )  
4 =ISEVEN( 20/4 )  
5 =ISEVEN( B5 ) 10
6 =ISEVEN( B6 )  
 Results:
  A B
1 TRUE  
2 FALSE  
3 TRUE  
4 FALSE  
5 TRUE 10
6 TRUE  

Note that the example in cell A1 shows that the Iseven function returns True for a zero value. Also, as seen in cell A6, an empty cell evaluates to zero and so the Iseven function also returns True in this case.


Iseven Function Error

If you get an error from the Excel Iseven function this is likely to be the #VALUE! error:

Common Error
#VALUE! - Occurs if the supplied number argument is not a numeric value
Return to the Excel Information Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net