The Excel ISODD Function

Related Functions:
ISEVEN
ISNUMBER

Basic Description

The Excel Isodd function tests if an initial supplied number (or expression) evaluates to an odd number, and if so, returns TRUE; Otherwise, the function returns FALSE.

The syntax of the function is:

ISODD( number )

Where the supplied 'number' argument is either a simple number, a formula that returns a numeric value, or a reference to a cell that contains a number.


Isodd Function Examples

The spreadsheets below show examples of the Excel Isodd function.

 Formulas:
 AB
1=ISODD( 0 ) 
2=ISODD( 1 ) 
3=ISODD( 2 ) 
4=ISODD( 20/4 ) 
5=ISODD( B5 )11
 Results:
 AB
1FALSE 
2TRUE 
3FALSE 
4TRUE 
5TRUE11

Further information and examples of the Excel Isodd function can be found on the Microsoft Office website.


Isodd Function Error

If you get an error from the Excel Isodd function, this is likely to be the #VALUE! error:

Common Error
#VALUE!-Occurs if the supplied number argument is non-numeric