Returns TRUE if number is even, or FALSE if number is odd.
If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.
Syntax
ISEVEN(number)
Number is the value to test. If number is not an integer, it is truncated.
Remarks
If number is nonnumeric, ISEVEN returns the #VALUE! error value.
Examples
ISEVEN(-1)
equals FALSE
ISEVEN(2.5)
equals TRUE
ISEVEN(5)
equals FALSE