# How to Use ISODD Function in Excel (4 Suitable Examples)

Get FREE Advanced Excel Exercises with Solutions!

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 ISODD function works in Excel independently and then with other Excel functions.

## Excel ISODD Function: Syntax & Arguments

Let’s learn about the ISODD function before diving into the examples. 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

## ISODD Function in Excel: 4 Suitable Examples

Now, I will talk about the examples one by one.

### Example 1: Find Odd Numbers Using ISODD Function

First of all, I will show you how to find odd numbers using the ISODD Function.

Steps:

• First of all, go to E5 and write down the following formula
`=ISODD(B5)` • Then, press ENTER to get the output. • After that, use the Fill Handle to AutoFill up to E12. ### Example 2: Highlight Odd Rows Using ISODD Function

Now, I will show another example highlighting odd numbers using the ISODD function.

Steps:

• First of all, select the dataset.
• Then, go to the Home
• After that, select Conditional Formatting.
• Finally, select New Rule. • A box will appear. Write down the formula in the Rule Description.
`=ISODD(ROW(B4:D12))`
• After that, select Format. • Excel will the Format Cells.
• Format the way you want. I changed the fill colors here. You can try something else.
• Then, click OK. • Excel will highlight the odd rows. ### Example 3: Highlight Odd Numbers Using ISODD Function

Now, I will explain how you can highlight odd numbers from a range using the ISODD function.

Steps:

• First of all, select the range. • Then, just like the previous method, bring up the New Formatting Rule
• After that, write down the following formula
`=ISODD(D5)`
• Then, click OK. • Excel will highlight the odd numbers. ### Example 4: Find Even and Odd Numbers Combining IF and ISODD Functions

The last example I am going to show is how you can find even and odd numbers using a combination of the IF and ISODD functions. For this example, I will use the dataset of the previous example. I have calculated the summation of all the marks and will determine which ones out of these marks are even or odd. Steps:

• Go to I5 and write down the following formula
`=IF(ISODD(H5),"Odd","Even")` • Then, press ENTER to get the output. • Then, use the Fill Handle to AutoFill up to D12. ## Things to Remember

• 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.
• If the number is not an integer, it is truncated.

## 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 all about the ISODD function. If you have any inquiries or feedback, please let us know in the comment section. Hello! Welcome to my Profile. Currently, I am working and researching Microsoft Excel, and here I will be posting articles related to this. My last educational degree is BSc, and my program was Computer Science and Engineering from American International University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  