ISEVEN ()
This function tests a number to determine whether it is even
or not.
Best view in desktop mode.
|
|
A |
B |
C |
D |
|
1 |
Values |
Is it Even ? |
||
|
2 |
1 |
FALSE |
=ISEVEN(A2) |
|
|
3 |
2 |
TRUE |
=ISEVEN(A3) |
|
|
4 |
2.5 |
TRUE |
=ISEVEN(A4) |
|
|
5 |
2.6 |
TRUE |
=ISEVEN(A5) |
|
|
6 |
3.5 |
FALSE |
=ISEVEN(A6) |
|
|
7 |
3.6 |
FALSE |
=ISEVEN(A7) |
|
|
8 |
Hello |
#VALUE! |
=ISEVEN(A8) |
|
|
9 |
5-Jan-21 |
FALSE |
=ISEVEN(A9) |
|
|
10 |
6-Jan-21 |
TRUE |
=ISEVEN(A10) |
|
|
11 |
||||
Decimal fractions values are ignored in this function. Cell A4, A5, A6, A7
Text values result in the #VALUE! Error. Cell A8
Dates can also be tested for Even or Odd. Cell A9, A10
Syntax
=ISEVEN (Number)
Format ting
No special formatting is
needed. Used by itself the result will be shown as TRUE or FALSE.
No comments:
Post a Comment