The Excel ISODD Function

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

Search this site:

Custom Search

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.

If the value provided to the function is not a number, the function returns the #VALUE! error.

The format of the ISODD function is :

ISODD( number )

Where the number argument can be a simple number, a formula or a cell reference.

Examples

The spreadsheets below show examples of the Excel ISODD function. The spreadsheet on the left shows the formulas used and the spreadsheet on the right shows the results :