Excel ISODD Function

What is ISODD function in Excel?

The ISODD function is one of the Information functions of Excel.

It Returns TRUE if the number is odd.

We can find this function in Information of insert function Tab.

How to use ISODD function in excel

1. Click on an empty cell (like F5).

2. Click on the fx icon (or press shift+F3).

3. In the insert function tab you will see all functions.

4. Select Information category.

5. Select ISODD function

6. Then select ok.

7. In the function arguments Tab you will see ISODD function.

8. Number section is the value to test.

9. You will see the results in the formula result section.

Examples of ISODD function in Excel

Example 1:

How to identify odd numbers in excel?

In the following examples, as you can see in the photo, odd numbers can be identified by the ISODD function.

=ISODD(1.5) ----->>>>answer is  TRUE
=ISODD(-2) ----->>>>answer is  FALSE
=ISODD(4) ----->>>>answer is  FALSE
=ISODD(5) ----->>>>answer is  TRUE
=ISODD(-3.5) ----->>>>answer is  TRUE

The decimal part of decimal numbers is ignored by this function. If the input of the numerical function is odd, the answer of the function will be true, otherwise, it will be false.

Example 2:

How to Highlight the odd rows of Excel?

We can use ISODD function to Highlight the odd rows in Excel:

1. Select the cells that want to be highlighted.

2. Select Conditional Formatting

3. Select Highlight cells rules

4. Select more rules.

5. In the New Formatting Rule tab you will see all Rules.

6. Select Use a formula to determine which cells to format.

7. write the below code in Format values where this formula is true.

=ISODD(ROW())

8. Select Format.

9 and 10. in the Format Cells, Select the Fill tab.

11. Choose your desired Color.

12. Select OK.

9. You will see the results in the following picture.

Example 3:

How to use ISODD function in python

num = int(input('Please enter the number: '))
result = num%2 == 0 and "even" or "odd"
print(result)

Errors in ISODD function

If the number is non-numeric, ISODD returns the #VALUE! error value.

ISODD related functions

• Use ISEVEN function to return TRUE if the number is even.
• Use ISNONTEXT function to check whether a value is not text, and returns TRUE or FALSE.
• Use ISREF function to check whether a value is a reference, and returns TRUE or FALSE.
• Use ISTEXT function to check whether a value is text, and returns TRUE or FALSE.