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.

Excel If Odd


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.

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

  • 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.

Apply Excel ISEVEN Function to Determine If a Number Is Odd

  • 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.

Read More: How to Determine If a Number Is Even in Excel


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.

Check If a Number is Odd Using IF Function in Excel

  • 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.

How to Filter an Odd Number in Excel

  • 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.

Read More: How to Sort Odd and Even Numbers in Excel 


Practice Section

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

Practice Section


Download Practice Workbook

You can download the workbook to practice yourself.


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.


Related Articles

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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo