# How to Use ISODD Function in Excel (With 4 Examples) 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.

ISODD Function in Excel (Quick View) ## Excel ISODD Function: Syntax & Arguments Summary

This function returns TRUE if the number is odd.

Syntax

`=ISODD (``number``)`

Arguments

Argument Required or Optional Value
number Required Pass the numeric value to check.

Note:

• 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

`=ISODD(D4)` ### 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

1. Select the marked option
2. Now write the formula in the formula box
`=ISODD(ROW(A4:D11))` 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

`=ISODD(D4)` 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

`=IF(ISODD(H4),"Odd","Even")`

Formula Explanation

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

## Conclusion

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.  