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).
empty cell in excel

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

fx icon in excel

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

insert function tab in excel

4. Select Information category.

5. Select ISODD function

6. Then select ok.

excel ISODD function

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.

How to use ISODD function in excel

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.

Examples of ISODD function in Excel
=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.

How to Highlight the odd rows of Excel?

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.

How to Highlight the odd rows of Excel?

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

11. Choose your desired Color.

12. Select OK.

How to Highlight the odd rows of Excel?

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

How to Highlight the odd rows of Excel?

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.

Leave a Reply

Your email address will not be published. Required fields are marked *