Excel ISEVEN Function

What is ISEVEN function in Excel?

The ISEVEN function is one of the Information functions of Excel.

It Returns TRUE if the number is even.

We can find this function in Information category of the insert function Tab.

How to use ISEVEN function in excel

  1. Click on an empty cell (like F5).
empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select Information category.

5. Select ISEVEN function

6. Then select ok.

excel ISEVEN function

7. In the function arguments Tab you will see ISEVEN function.

8. Number section is the value to test.

9. You will see the results in the formula result section.

How to use ISEVEN function in excel

Examples of ISEVEN function in Excel

Example 1:

How to identify Even numbers in excel?

In the following examples, as you can see in the photo, Even numbers can be identified by the ISEVEN function.

Examples of ISEVEN function in Excel
=ISEVEN(1.5) ----->>>>answer is  FALSE
=ISEVEN(-2) ----->>>>answer is  TRUE
=ISEVEN(4) ----->>>>answer is  TRUE
=ISEVEN(5) ----->>>>answer is  FALSE
=ISEVEN(-3.5) ----->>>>answer is  FALSE

Example 2:

How to Highlight the Even rows of Excel?

We can use ISEVEN function to Highlight the even rows in Excel:

1.Select the cells that want to be highlighted.

2. Select Conditional Formatting

3. Select Highlight cells rules

4. Select more rules.

5. In the New Formatting Rule tab you will see all Rules.

6. Select Use a formula to determine which cells to format.

7. write the below code in Format values where this formula is true.


8. Select Format.

9 and 10. in the Format Cells, Select the Fill tab.

11. Choose your desired Color.

12. Select OK.

9. You will see the results in the following picture.

Example 3:

Python code for ISEVEN function

num = int(input('Please enter the number: '))
result = num%2 == 0 and "even" or "odd"

ISEVEN related functions

  • Use ISODD function to return TRUE if the number is odd.
  • Use ISBLANK function to check whether a reference is to an empty cell, and return TRUE or FALSE.
  • Use ISNUMBER function to check whether a value is a number, and return TRUE or FALSE.
  • Use ISTEXT function to check whether a value is text, and returns TRUE or FALSE.

Leave a Reply

Your email address will not be published. Required fields are marked *