ISODD

Posted on 18-01-2020 , by: admin , in , 0 Comments

isodd

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.

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)

Leave a comment