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