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
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Information category.
5. Select ISEVEN function
6. Then select ok.
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.
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.
=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 FALSEExample 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.
=ISEVEN(row())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"
print(result)
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.
