ISEVEN

ISEVEN(number)

Returns the boolean True or False depending if the value is an even number.

number

The number you want to test.

REMARKS

* If "number" is not an integer, it is truncated.
* If "number" is not numeric, then #VALUE! is returned.
* Any numbers enclosed in double quotation marks are converted to numbers.
* You can use the ISODD function to return True or False depending if the value is an odd number.
* You can use the ISNUMBER function to return True or False depending if the value is a number.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=ISEVEN(2.5) = True
2	=ISEVEN("2") = -1
3	=ISEVEN("0") = True
4	=ISEVEN(-1) = False
5	=ISEVEN(5) = False
6	=ISEVEN(23) = False
7	=ISEVEN("some text") = #VALUE!

1 - Is the number 2.5 an even number. This decimal number will be truncated to 2.
2 - Is the text string "2" an even number. This is converted to a number.
3 - Is the text string "0" an even number. This is converted to a number.
4 - Is the number -1 an even number.
5 - Is the number 5 an even number.
6 - Is the number 23 an even number.
7 - Is the text string "some text" an even number.