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.

**Table of Contents**hide

## Download the Practice Workbook

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

- Select the marked option
- 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.- 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. |

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

**Further Readings**

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