The Excel ISEVEN function checks whether a given number is even or not. It returns TRUE if the number is even and FALSE if it’s odd. This function can be helpful in various scenarios, like filtering data, performing calculations, or making decisions based on even or odd values.
Syntax
ISEVEN(number)
Arguments
| number | The number you want to check for evenness. |
How to use
To use the Excel ISEVEN function, follow these steps:
1. Begin with an Excel worksheet where you want to check if a number is even or not.
2. Select the cell where you want to display the result of the ISEVEN function.
3. Enter the following formula in the selected cell:
|
1 |
=ISEVEN(number) |
Replace ‘number’ with the actual number you want to check for evenness.
4. Press Enter, and the cell will display either TRUE (if the number is even) or FALSE (if the number is odd).
Examples
Let’s look at a few examples of using the ISEVEN function:
Example 1: Check if the number 6 is even or not:
|
1 |
=ISEVEN(6) |
This formula will return TRUE since 6 is an even number.
Example 2: Check if the number 7 is even or not:
|
1 |
=ISEVEN(7) |
This formula will return FALSE since 7 is an odd number.
Example 3: Use a cell reference to check evenness:
|
1 |
=ISEVEN(A1) |
If cell A1 contains a number, this formula will return TRUE if it’s even and FALSE if it’s odd.
Example 4: Combine ISEVEN with other functions:
|
1 |
=IF(ISEVEN(A2), "Even", "Odd") |
This formula checks if the number in cell A2 is even using ISEVEN and displays “Even” if true and “Odd” if false.
Additional information
If you need to check if a number is odd, you can use the ISODD function, which works similarly to ISEVEN but returns TRUE for odd numbers. ISEVEN and ISODD can be useful for various tasks, such as conditional formatting, data analysis, and decision-making in Excel.