The ISEVEN function in Excel is used to check if a number is even.



number The number you want to check if it is even.


When you need a quick way to determine whether a number is even or not in Excel, turn to the ISEVEN function. This function comes in handy when working with datasets and wanting to categorize numbers based on their parity – whether they are divisible by 2 without a remainder. It simplifies the process of identifying even numbers within your data, aiding in various analytical and computational tasks where the number's divisibility by 2 is a key factor.


If you want to check if the number 14 is even, use the formula: =ISEVEN(14). This will return TRUE since 14 is an even number.

To verify if 77 is an even number, enter: =ISEVEN(77). This will result in FALSE as 77 is an odd number.


What does the ISEVEN function return?

The ISEVEN function returns TRUE if the provided number is even, and FALSE if it is odd.

Can I use the ISEVEN function with non-numeric values?

No, the ISEVEN function is designed to work with numeric values only. If you try to use non-numeric values, it will result in an error or return FALSE.

How can I combine the ISEVEN function with other functions in Excel?

You can combine the ISEVEN function with logical functions like IF, AND, or OR to create more complex formulas based on even or odd number conditions. For instance, you can use it within an IF function to perform specific actions based on whether a number is even or not.

Related functions