The ISEVEN function checks if the value is an even number.
Returns TRUE if it is and FALSE if not.
This function can be useful when you need to filter or process data based on the parity of numbers.
Syntax
ISEVEN(value)
Argument |
Description |
Permitted values |
|---|---|---|
value |
Value that is checked for parity |
Any number. Can be specified as a number, formula, function, or cell reference |
Examples of use
Checking the parity of a number
=ISEVEN(4)
The formula will return TRUE, since 4 is an even number.
Use in a conditional formula
=IF(ISEVEN(A1), "Even", "Odd")
If the value in cell A1 is even, the formula will return “Even”; otherwise, it will return “Odd.”
Notes
–The ISEVEN function returns TRUE for even numbers and FALSE for odd numbers.
–If the number is not an integer, it is rounded to the nearest integer before being checked.
–For negative numbers, parity or oddness is also determined.
–If the argument is not a number, the function returns the #VALUE! error.