Purpose
Return value
Syntax
=ISEVEN(value)- value - The numeric value to check.
Using the ISEVEN function
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.
ISEVEN function examples
Highlight every other row
Shade alternating groups of n rows
Count cells that contain odd numbers
ISEVEN function videos
How to apply conditional formatting with a formula
Shade groups of rows with conditional formatting
How to create zebra stripes with conditional formatting
Related functions
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.
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.
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.
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 run a different calculation when an error occurs....
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.
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.
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.
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.
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.
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.
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 value entered as text.
