How to Verify Odd and Even Using IF Function in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.

IF Function Excel Odd Even


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

Combine ISEVEN and IF Functions to Verify Odd and Even

  • 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")

Merge IF and MOD Functions to Verify Odd and Even in Excel

  • 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")

Combine ISODD and IF Functions to Verify Odd and Even in Excel

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


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , and premium Excel consultancy services for Excel and business users. Feel free to contact us with your Excel projects.
Naimul Hasan Arif
Naimul Hasan Arif

Hello everyone, I am Naimul Hasan Arif, graduated from Bangladesh University of Engineering and Technology (BUET). I am working as an Excel and VBA Content Developer. I try to remain dedicated to my duties and give my best with my skills & knowledge.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo