Excel ISEVEN Function

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.
- value - The numeric value to check.
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:
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:
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.