How to use ISEVEN Function in Excel

The Excel ISEVEN function returns TRUE when a numeric value is even, and FALSE for odd numbers. ISEVEN will return the #VALUE error when a value is not numeric.

Syntax:= ISEVEN (value)

The ISEVEN function syntax has the following arguments:

  • Number (required argument) – This is the value we wish to test. If it is not an integer, the value is truncated.

Example: Let’s look at some Excel ISEVEN function examples and explore how to use the ISEVEN function as a worksheet function in Microsoft Excel:

ISEVEN Function - How to use ISEVEN Function in Excel

Syntax:  =ISEVEN(A2)

Result:

ISEVEN Function in Excel - How to use ISEVEN Function in Excel

Based on the Excel spreadsheet above, the following ISEVEN examples would return:

Syntax: =ISEVEN(A3)
Result: FALSE

Syntax: =ISEVEN(A4)
Result: TRUE

Syntax: =ISEVEN(A5)
Result: TRUE

Syntax: =ISEVEN(A6)
Result: TRUE

Syntax: =ISEVEN(A7)
Result: FALSE

Syntax: =ISEVEN(A8)
Result: FALSE

Syntax: =ISEVEN(A9)
Result: TRUE

Syntax: =ISEVEN(A10)
Result: FALSE

Syntax: =ISEVEN(A11)
Result: FALSE

Note:

Use the ISEVEN function to check if a numeric value is an even number. ISEVEN will return TRUE when a numeric value is even and FALSE when a numeric value is odd. If value is not numeric, ISEVEN will return the #VALUE error.

For example, =ISEVEN(A1) will return TRUE if A1 contains the number 2 and FALSE if A1 contains the number 3.

Usually, value is supplied as a cell address.

ISEVEN is part of a group of functions called the IS functions that all return the logical values TRUE or FALSE.

READ:  How to use ISNA Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *