The ISODD is one of the Excel information functions. It is a reference function that assists to show if a given number is odd or not. This article will share the complete idea of how the RIGHT function works in Excel independently and then with other Excel functions.
Download the Practice Workbook
ISODD Function in Excel (Quick View)
Excel ISODD Function: Syntax & Arguments
This function returns TRUE if the number is odd.
|Argument||Required or Optional||Value
|number||Required||Pass the numeric value to check.|
- Normally, the value is supplied as a cell address.
- The ISODD is part of a group of functions named the IS functions that all return the logical values TRUE or FALSE.
- This function is the opposite of the ISEVEN function.
- If the number is not an integer, it is truncated.
How to Use the ISODD Function in Excel (4 Examples)
Example 1: Find Odd Numbers Using ISODD Function
Let’s have a dataset of employees with their ID, Name, and Department. Now we will find out the IDs which are containing odd numbers.
Step 1: Enter the formula in cell E4 and copy it down up to E11
Example 2: Highlight Odd Numbers Using ISODD Function
Using the ISODD function we can format cells using the conditional formatting option. For this, we will use the same dataset above.
Step 1: Select the dataset
Step 2: Now click on the Conditional Formatting option
Step 3: Click on the New Rule option
Step 4: Now follow the process
- Select the marked option
- Now write the formula in the formula box
Step 5: Change format color as per your requirement
Step 6: Now click on the button
Step 7: The format of the whole dataset will be changed
Example 3: How to Highlight Odd Rows Using ISODD Function
Now in this section, we will see how to highlight the cells that contain any odd numbers. For this process let’s assume a dataset of students’ grade marks. Among the marks, we will highlight those marks which are odd.
Step 1: Follow the same steps 1 to 4 as example 3
Step 2: Now enter the formula in the formula box
Step 3: Now change the format color as per your need like step 5 in the previous example. Then press the OK button
Step 4: Your data format will be changed
Example 4: Find Even and Odd Numbers Using IF and ISODD Functions
Now in this section, we will see whether the total sum of each student is odd or even using IF and ISODD functions.
Step 1: Enter the formula in cell I4 and copy it down up to I14
- Here the outer function is the IF function. ISODD(H4) is the logical part.
- “Odd” will be printed if the logical part returns true.
- “Even” will be printed if the logical part returns false.
- If you want to explore more about this IF function you can check this link
Things to Remember
|Common Errors||When they show|
|#VALUE!||This will occur when the given argument is non-numeric.|
|Not Available||The ISODD function was introduced in Excel 2007 and, therefore, is unavailable in earlier versions. It will return an error if used in more initial versions. For earlier versions, we can use the MOD function.|
To conclude, I have tried to give a summary of the ISODD function and its different applications. I have shown multiple methods with their respective examples but there can be many other iterations depending on numerous situations. That’s it all about the ISODD function. If you have any inquiries or feedback, please let us know in the comment section.
- How to Use ISLOGICAL Function in Excel (4 Examples)
- How to Use ISTEXT Function in Excel (3 Examples)
- How to use ISNA function in Excel (4 Examples)
- How to Use ISNUMBER Function in Excel (7 Examples)
- How to Use ISBLANK Function in Excel (2 Examples)
- How to Use ISERROR Function in Excel (With 5 Examples)