How to Use ISODD Function in Excel (With 4 Examples)

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.

Download the Practice Workbook

ISODD Function in Excel (Quick View)

Overview of ISODD Function

Excel ISODD Function: Syntax & Arguments

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.

Find Odd Numbers Using ISODD Function

Step 1: Enter the formula in cell E4 and copy it down up to E11

=ISODD(D4)

Enter formula using ISODD Function

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

Select the dataset

Step 2: Now click on the Conditional Formatting option

Click on Conditional formatting

Step 3: Click on the New Rule option

Click on New Rule

Step 4: Now follow the process

  1. Select the marked option
  2. Now write the formula in the formula box
    =ISODD(ROW(A4:D11))
    New formattiing rule

Step 5: Change format color as per your requirement

Format cells colors

Step 6: Now click on the button

Now Now click on the button

Step 7: The format of the whole dataset will be changed

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.

How to Highlight Odd Rows Using ISODD Function

Step 1: Follow the same steps 1 to 4 as example 3

Step 2: Now enter the formula in the formula box

=ISODD(D4)

Formatting rules

Step 3: Now change the format color as per your need like step 5 in the previous example. Then press the OK button

Press ok button

Step 4: Your data format will be changed

Output of the conditional formatting

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.

 Find Even and Odd Numbers Using IF and ISODD Function

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

Enter formula using IF and ISODD Function

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

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