ISEVEN

ISEVEN(number)

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

numberThe 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.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top