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
ISEVEN(number)
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.
=ISEVEN(2) returns 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.
