Home » Excel-Built-In-Functions » Excel-Information-Functions » Excel-Isodd-Function

The Excel ISODD Function

Related Functions:
ISEVEN
ISNUMBER

Function Description

The Excel Isodd function tests if a supplied number (or numeric 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 the value or expression to be tested.


Isodd Function Examples

The spreadsheet below shows five examples of the Excel Isodd function:

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

For further details and examples of the Excel 'Is' functions, see 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.
Return to the Excel Information Functions Page
Return to the List of All Built-In Excel Functions