How to Use ISODD Function in Excel (4 Suitable 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 ISODD function works in Excel independently and then with other Excel functions.


Download Practice Workbook

Download this workbook and practice.


Excel ISODD Function: Syntax & Arguments

Let’s learn about the ISODD function before diving into the examples.

Excel ISODD Function

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

4 Suitable Examples of ISODD Function in Excel

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.

Finding Odd Numbers Excel ISODD Function

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

Highlighting Odd Rows Excel ISODD Function

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

Highlighting Odd Rows Excel ISODD Function

  • Excel will highlight the odd rows.

Highlighting Odd Rows Excel ISODD Function


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.

Highlighting Odd Numbers Excel ISODD Function

  • Excel will highlight the odd numbers.

Excel ISODD Function


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.

Highlighting Odd Numbers Excel ISODD Function

Steps:

  • Go to I5 and write down the following formula
=IF(ISODD(H5),"Odd","Even")

  • Then, press ENTER to get the output.

Highlighting Odd Numbers Excel ISODD Function

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


Further Readings

Md. Abdullah Al Murad

Md. Abdullah Al Murad

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

Leave a reply

ExcelDemy
Logo