**What is the Excel ISEVEN Function?**

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.

**ISEVEN Syntax**

ISEVEN(number)

number, required, the numeric value to test

Usage Note:

- Returns a #VALUE! error if non-numeric fills the number argument
- All decimal fractions truncated to an integer number

**How to Use ISEVEN Function in Excel**

For example, there is data like the image below. What is the result of the ISEVEN function in column B?

**ISEVEN Function #1**

=ISEVEN(A1)

The result is TRUE. Zero is an even number, has no remainder if divided by the number 2

**ISEVEN Function #2**

=ISEVEN(A2)

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.

Please read the article below for a detailed explanation of how dates and times stored in Excel

**ISEVEN Function #3**

=ISEVEN(A3)

The result is #VALUE! error. TRUE is a logical value, not a number.

**ISEVEN Function #4**

=ISEVEN(A4)

The result is FALSE. 3 is an odd number, positive or negative.

**ISEVEN Function #5**

=ISEVEN(A5)

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**

=ISEVEN(A6)

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