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

Get FREE Advanced Excel Exercises with Solutions!

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.

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

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.

### 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 was 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 an odd one.

### 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 of 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 was odd or even.
• Then, we used the IF function to get a resultant as Odd for the TRUE value and Even for the FALSE value.

Read More: How to Fill Odd Numbers in Excel

## 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:

• First, 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 be added 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. ## Practice Section

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

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems. Arin Islam

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  