ISEVEN Function (Functions in Excel)
Number | Is it Even | |
1 | FALSE | =ISEVEN(C4) |
2 | TRUE | =ISEVEN(C5) |
2.5 | TRUE | =ISEVEN(C6) |
2.6 | TRUE | =ISEVEN(C7) |
3.5 | FALSE | =ISEVEN(C8) |
3.6 | FALSE | =ISEVEN(C9) |
Hello | #VALUE! | =ISEVEN(C10) |
1-Feb-98 | FALSE | =ISEVEN(C11) |
1-Feb-96 | TRUE | =ISEVEN(C12) |
What Does It Do ? |
This function tests a number to determine whether it is even. |
An even number is shown as TRUE an odd number is shown as FALSE. |
Note that decimal fractions are ignored. |
Note that dates can be even or odd. |
Note that text entries result in the #VALUE! error. |
Syntax |
=ISEVEN(CellToTest) |
Formatting |
No special formatting is required. |
0 comments:
Post a Comment