Verifying whether a number is odd or even can be a useful task in a variety of situations, such as data analysis or creating formulas for spreadsheets. In Excel, you can use the IF function to check whether a number is odd or even and return a specific value based on the result. In this article, I will explain 3 suitable ways to verify odd and even using the IF function in Excel. I hope it will be very helpful for you if you are looking for an efficient way to do so.
How to Check Odd and Even Using IF Function in Excel: 3 Suitable Ways
In order to verify odd and even using the IF function, I have added 3 more functions. They are the ISEVEN, MOD, and ISODD functions. To make it more clear, I have prepared a dataset with marks in Physics to check whether the student got even marks or odd. I have arranged the data in the Roll, Full Name, Physics, and Remarks columns. Let’s go through it for more details.
1. Combine ISEVEN and IF Functions to Verify Odd and Even in Excel
A combination of the ISEVEN and IF functions is a very simple and smart way to verify odd and even in Excel. The whole process is described below in detail.
Steps:
- Select a cell according to your preference (i.e. E5).
- Next, insert the following formula in that cell and press ENTER to verify odd and even.
=IF(ISEVEN(D5),"Even","Odd")
- After that, use Fill Handle to AutoFill the rest cells in column E.
Read More: How to Fill Odd Numbers in ExcelÂ
2. Merge IF and MOD Functions to Verify Odd and Even in Excel
Another smart way to verify the odd and even is to merge IF and MOD functions and define a proper output. Let’s dive into detail.
Steps:
- Pick a suitable location and input the following formula in that place to verify odd and even.
=IF(MOD(D5,2)=0, "Even","Odd")
- AutoFill the rest cells in column E using Fill Handle.
3. Combine ISODD and IF Functions to Verify Odd and Even in Excel
Almost similar to the process of the fusion of the ISEVEN and IF functions, we can also create a formula with the ISODD and IF functions and verify the odd and even. Follow the following steps for more details.
Steps:
- First, select a cell according to your preference (i.e. E5).
- Next, apply the following formula in that cell and press ENTER to verify odd and even.
=IF(ISODD(D5),"Odd","Even")
- Finally, you can use Fill Handle to AutoFill the rest cells in column E.
Read More: How to Check If a Number Is Odd or Even with Excel VBA
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
At the end of this article, I like to add that I have tried to explain 3 suitable ways to verify odd and even using the IF function in Excel. It will be a great pleasure for me if this article helps any Excel user even a little. For any further queries, comment below.