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.
* 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.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

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


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