## Summary

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.

## Purpose

Test if a value is even

## Return value

A logical value (TRUE or FALSE)

## Syntax

``=ISEVEN(value)``
• value - The numeric value to check.

## How to use

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:

``````=ISEVEN(4) // returns TRUE
=ISEVEN(3) // returns FALSE
=ISEVEN(0) // returns TRUE
``````

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:

``````=ISEVEN(4.1) // returns TRUE
=ISEVEN(0.33) // returns TRUE
=ISEVEN(7.4) // returns FALSE
``````

### 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.

Author

### Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.