We can use the Excel **ISODD function** to test whether an imputed numerical value is an odd number. This article will walk through the simple steps.

*Figure 1 – How to Use the Excel ISODD function*

**General Formula**

**=ISODD(value)**

- “Value” is the numerical value we want to test if
**it is ODD**

**Formula**

**=ISODD(B5)**

**Setting up the Data**

We will structure our table in the pattern as shown in figure 2. We want to check if each number under the **“value”** column is an odd number.

- We will input the values in the range
**B5:B10** - The
**RESULTS**will be displayed in**Column C**

* Figure 2 – Setting up the data*

**Using the Excel ISODD function**

- We will click on
**Cell C5** - We will insert the formula below into
**C5**

**=ISODD(B5)**

* Figure 3 – Applying the Excel ISODD function*

- We will press the
**enter key**

* Figure 4- How to use the Excel ISODD function*

- We will use the fill handle to copy the formula into the remaining cells to get the result.

* Figure 5 – Final Result of applying the Excel ISODD function*

**Explanation**

The **ISODD function** checks if the specified value or cell reference has an **ODD number** and returns the result with a **TRUE **or **FALSE**. If there is no numeric value in the cell, then the ISODD function will return the #VALUE error.

**Instant Connection to an Expert through our Excelchat Service**

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

## Leave a Comment