The **ISODD **Excel function is an *Information *formula that returns *TRUE* if the **number** argument is an *odd *number, or *FALSE* if it’s *even*. You can test the result of a formula or value of a cell using this function. In this guide, we’re going to show you how to use the **ISODD **function and also go over some tips and error handling methods.

## Supported versions

- All Excel versions

## ISODD Excel Function Syntax

## Arguments

number |
The number you want to test. |

## Example

The **ISODD** function, just like the other **IS…** functions, only requires a single argument as an input. The function returns a *TRUE* logical value if the **number** argument is an odd number. If the number has decimals, the **ISODD** function truncates the **number** argument. A common use case of this function is testing the value of cell or value that is returned by a formula.

*TRUE*

=ISODD(2) returns *FALSE*

## Tips

- You can use the
**ISODD**function for the logical test component of an**IF**function.=IF(ISODD(A1),”Odd number”,”Even number”) - If the
**number**is not a whole number, the**ISODD**function truncates the numeric value. - Excel keeps date and time values as numbers. Excel assumes that
*Jan 1st, 1900*is*1*, and every subsequent date value is based on this. While whole numbers represent days, decimals represent time values. For example;*1/1/2018*is equal to*43101*, and*12:00*is equal to*5*. Because of this, the**ISODD**function counts date time values as numbers. - Below is a list of other
**IS…**functions:- ISBLANK to test blank cells
- ISERR to test error values except #N/A
- ISERROR to test all error values
- ISNA to test #N/A error value specifically
- ISNUMBER to test numbers
- ISTEXT to test any item that is a text
- ISNONTEXT to test any item that is not a text
- ISEVEN to test even numbers
- ISREF to test if a formula returns a reference

## Issues

- If the
**number**argument is not a valid numeric value, the**ISODD**function returns a #*VALUE!*error.