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