ISODD Function In Excel With Example

ISODD ()

This function tests a number to determine whether it is odd or not.

It will show TRUE for any odd number and FALSE for even number.

Best view in desktop mode.

	A	B	C	D
1	Values	Is it Odd ?
2	1	TRUE	=ISODD(A2)
3	2	FALSE	=ISODD(A3)
4	2.5	FALSE	=ISODD(A4)
5	2.6	FALSE	=ISODD(A5)
6	3.5	TRUE	=ISODD(A6)
7	3.6	TRUE	=ISODD(A7)
8	Hello	#VALUE!	=ISODD(A8)
9	5-Jan-21	TRUE	=ISODD(A9)
10	6-Jan-21	FALSE	=ISODD(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 Odd or Even. Cell A9, A10

 

 

 

Syntax

=ISODD (Number)

 

 

 

Formatting

No special formatting is needed.

 

 

 

 

ISNUMBER in Excel

<<  Previous

Next  >>

ISTEXT in Excel