How to use the 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

Excel 2003

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.

Related functions

Excel ISODD Function

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

Excel ISBLANK Function

The Excel ISBLANK function returns TRUE when a cell is empty, and FALSE when a cell is not empty. For example, if A1 contains "apple", ISBLANK(A1) returns FALSE.

Excel ISERR Function

The Excel ISERR function returns TRUE for any error type except the #N/A error. You can use the ISERR function together with the IF function to test for an error and display a custom message, or perform a different calculation if found.

Excel ISERROR Function

The Excel ISERROR function returns TRUE for any error type excel generates, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! You can use ISERROR together with the IF function to test for errors and display a custom message, or...

Excel ISFORMULA Function

The Excel ISFORMULA function returns TRUE if a cell contains a formula, and FALSE if not. When a cell contains a formula ISFORMULA will return TRUE regardless of the formula's output or error conditions.

Excel ISLOGICAL Function

The Excel ISLOGICAL function returns TRUE when a cell contains the logical values TRUE or FALSE, and returns FALSE for cells that contain any other value, including empty cells.

Excel ISNA Function

The Excel ISNA function returns TRUE when a cell contains the #N/A error and FALSE for any other value, or any other error type. You can use the ISNA function with the IF function test for #N/A and display a friendly message if the error occurs...

Excel ISNONTEXT Function

The Excel ISNONTEXT function returns TRUE when a cell contains any value except text. This includes numbers, dates, times, errors, and formulas that do not return text. ISNONTEXT also returns TRUE when a cell is empty.

Excel ISNUMBER Function

The Excel ISNUMBER function returns TRUE when a cell contains a number, and FALSE if not. You can use ISNUMBER to check that a cell contains a numeric value, or that the result of another function is a number.

Excel ISREF Function

The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not. You can use the ISREF function to check for a reference in a formula.

Excel ISTEXT Function

The Excel ISTEXT function returns TRUE when a cell contains a text value, and FALSE if the cell contains any other value. You can use the ISTEXT function to check if a cell contains a text value, or a numeric...