Looking for ways to check **if **a number is **odd **in Excel? Then, this is the right place for you. You can easily do that by using some functions. Here, you will find **3 **ways to check **if **a number is **odd **in Excel.

**Table of Contents**hide

## Download Practice Workbook

You can download the workbook to practice yourself.

## 3 Easy Ways to Check If a Number Is Odd in Excel

Here, we have a dataset containing some studentsâ€™ **Names** and **ID** **No**. Now, we will show you how to check **if **these **IDs No **are **odd **or even.

### 1. Use ISODD Function to Check If a Number Is Odd in Excel

In the first method, we will use **the ISODD function** to check **if **a number is **odd **or even in Excel. Follow the steps given below to do that.

**Steps:**

- Firstly, select
**Cell D5**and insert the following formula.

`=ISODD(C5)`

- Then, press
**Enter**and drag down the**Fill Handle**tool to**AutoFill**the formula for the rest of the cells.

- Finally, you will get
**TRUE**if the**ID No**is**odd**and**FALSE**if it is**not**.

Here, in the **ISODD **function, we inserted **Cell C5 **as the **number **to check **if **it is an **odd **or even number.

**Read More: ****How to Verify Odd and Even Using IF Function in Excel**

### 2. Apply Excel ISEVEN Function to Determine If a Number Is Odd

You can also apply **the ISEVEN function** to determine **if **any number is **odd **or not. If a number is not even, it is definitely odd. So, to have a more direct result we will use **the NOT function** along with the **ISEVEN **function to check **if **a number is **odd **in Excel.

Here are the steps.

**Steps:**

- In the beginning, insert the following formula in
**Cell D5**.

`=NOT(ISEVEN(C5))`

- After that, press
**Enter**and drag down the**Fill Handle**tool for the rest of the cells.

- Thus, you can apply the
**ISEVEN**function to check**if**a number is**odd**or even.

ðŸ”Ž** How Does the Formula Work?**

- Firstly, we used the
**ISEVEN**function to check**if**the number is**odd**or even. - Secondly, we used the
**NOT**function to get the opposite form of the result as it shows**TRUE**for an**even**value and**FALSE**for**odd**one.

**Read More: ****Excel Formula for Finding Odd or Even Numbers**

### 3. Check If a Number Is Odd Using IF Function

In the last method, we will use the **IF** and **ISODD **functions to check **if **a number is **odd **and get a direct result as **Odd **or **Even**. Go through the steps given below to do it on your dataset.

**Steps:**

- To start with, insert the following formula in
**Cell D5**and press**Enter**.

`=IF(ISODD(C5),"Odd","Even")`

- Next, drag down the
**Fill Handle**tool to**AutoFill**the formula for the rest of the cells.

- Finally, you will get
**Odd**as a result if the**ID No**is**odd**and**Even**if it is**not**.

ðŸ”Ž** How Does the Formula Work?**

- In the beginning, we used the
**ISODD**function to check**if**the number is**odd**or even. - Then, we used the
**IF**function to get a resultant as**Odd**for**TRUE**value and**Even**for**FALSE**value.

**Read More: ****How to Fill Odd Numbers in Excel (5 Suitable Examples)**

## How to Filter an Odd Number in Excel

Additionally, we will show you how to **filter **an **odd **number from your dataset in Excel. To do that follow the steps given below.

**Steps:**

- Firstly, check
**if**a number is**odd**or even using any of the methods given above.

- Then, select your dataset. Here, we will select cell range
**B4:D9**. - After that, go to the
**Home**tab >> expand**Editing**>> click on**Sort & Filter**>> select**Filter**.

- Thus,
**filter**buttons will add to every column. - Now, click on the
**filter**button of the column which states if the number is**odd**or**even**. - Next, turn on only the
**TRUE**option. - Lastly, click on
**OK**.

- Finally, you will see that all the
**odd**numbers have been filtered.

**Read More: ****How to Sort Odd and Even Numbers in Excel (4 Easy Examples)**

## Practice Section

In the article, you will find an Excel workbook like the image given below to practice on your own.

## Conclusion

So, in this article, we have shown you **3 **ways to check **if **a number is **odd **in Excel. I hope you found this article interesting and helpful. If something seems difficult to understand, please leave a comment. Please let us know if there are any more alternatives that we may have missed. And visit **ExcelDemy** for many more articles like this. Thank you!