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

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

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

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 Advanced Excel Exercises with Solutions PDF  