The Excel **ISEVEN **function is an *Information *formula that returns *TRUE* if the **number **input is *even*, and *FALSE* if it is *odd*. You can test the result of a formula or value of a cell using this function. In this guide, we’re going to show you how to use the Excel **ISEVEN **function and also go over some tips and error handling methods.

## Supported versions

- All Excel versions

## Excel ISEVEN Function Syntax

## Arguments

number |
The number you want to test. |

## Example

The **ISEVEN** function, just like the other **IS…** functions, only requires a single argument as an input. The function returns a *TRUE* logical value if the **number** argument is an even number. If the number has decimals, the **ISEVEN** function truncates the value and evaluates it accordingly. A common use case for this function is testing the value of cell or value that returns from a formula.

*TRUE*

=ISEVEN(1) returns *FALSE*

## Tips

- You can use the Excel
**ISEVEN**function for the logical test of an**IF**function.=IF(ISEVEN(A1),”Even number”,”Odd number”) - If the
**number**is not a whole number, the**ISEVEN**function truncates the numeric value. - Excel keeps date and time values as numbers. Excel assumes that
*Jan 1st, 1900*is*1*, and every subsequent date value is based on this. While whole numbers represent days, decimals represent time values. For example;*1/1/2018*is equal to*43101*, and*12:00*is equal to*5*. Because of this approach, the**ISEVEN**function counts date time values as numbers. - Below is a list of other
**IS…**functions:- ISBLANK to test blank cells
- ISERR to test error values except #N/A
- ISERROR to test all error values
- ISNA to test #N/A error value specifically
- ISNUMBER to test numbers
- ISTEXT to test any item that is a text
- ISNONTEXT to test any item that is not a text
- ISODD to test odd numbers
- ISREF to test if a formula returns a reference

## Issues

- If the
**number**argument is not a valid numeric value, the**ISEVEN**function returns a #*VALUE!*error.