## Excel ISEVEN function

As the name suggests, the Excel ISEVEN function is a built-in function of the Excel which determines whether a given numeric value is even or not. This function returns a logical TRUE for even numbers and FALSE for the odd ones.

## Syntax

`=ISEVEN(value)`

## Argument

**value** – This includes (or)contains the numeric value to be checked.

## How does the function work?

- The Excel ISEVEN function checks the value parameter which contains s a numeric value.
- This function then returns a TRUE (or) FALSE depending, if the value is even or an odd TRUE value returned indicates an even value and a FALSE value returned indicates an odd numeric value. Also, note that if the non_numeric value is entered as a value parameter then Excel ISEVEN function returns the #VALUE! Error.
- For example, =ISEVEN(C1) ,say cell C1 contains a numeric value. This will return a TRUE if C1 contains an even number (2,4,6…) or returns a FALSE if C1 contains an odd number (1,3,5,7….).

## Note on ISEVEN formula examples

The excel ISEVEN function, when combined with other built-in functions, can perform a different unique operation some of these includes.

- Shading(or) highlighting an alternate group of ‘n’ rows can be done when used with a ROW, CEILING function.
- To highlight every other row in a list, when used with ISEVEN or ISODD functions.

## Example

Let us consider a table with a list of random values and determine the even numbers by using the Excel ISEVEN function .the table is as shown below.

*Figure 1. Shows the results for different numeric values using the Excel ISEVEN function*

## Leave a Comment