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.


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.


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.


<< Go Back to | Excel for Math | Excel ODD or EVEN | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Naimul Hasan Arif
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo