Even numbers are an integer number “evenly divisible” by 2; there is no remainder. Excel provides a function to check whether a number is even or not with the ISEVEN function without having to know if there is any remainder. Returns TRUE if the even number and FALSE if not.
number, required, the numeric value to test
- Returns a #VALUE! error if non-numeric fills the number argument
- All decimal fractions truncated to an integer number
For example, there is data like the image below. What is the result of the ISEVEN function in column B?
ISEVEN Function #1
The result is TRUE. Zero is an even number, has no remainder if divided by the number 2
ISEVEN Function #2
The result is FALSE. Excel stores date in the form of integer numbers, 1 represents January 1, 1900, 2 represents January 2, 1900, and so on.
January 1, 1900, is equal to 1, an odd number.
ISEVEN Function #3
The result is #VALUE! error. TRUE is a logical value, not a number.
ISEVEN Function #4
The result is FALSE. 3 is an odd number, positive or negative.
ISEVEN Function #5
The result is TRUE. 4.50E+06 is 4,500,000, only need to see the last digit of a number to determine odd/even. Zero is an even number.
ISEVEN Function #6
The result is FALSE. 5 is an odd number, if divided by 2 has a remaining number.
Please see the image below for the results of the six functions above