ISODD
Numerical Information Functions

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. The formulas are displayed in the spreadsheet on the left and the results are shown in the spreadsheet on the right:

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

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
Excelq.com doing business as a Service of Venttraffic Media Inc. Excel and other words on this site may be trademarks or registered trademarks of Microsoft Corporation. Microsoft Corporation is not connected in any way with this website, and makes no endorsement of the site or its related contents. All rights reserved. Website powered by Venttraffic Media Inc.