ISODD function

The ISODD function in Excel checks whether a number is odd. It returns TRUE if the number is odd and FALSE if the number is even.

Syntax:

ISODD(number)

Arguments:

• number: The value or cell reference that you want to check for being odd.

Example:

Example 1: Cell contains an odd number

• Data in A1: 5
• Formula:

  =ISODD(A1)
  

• Result: TRUE (since 5 is an odd number).

Example 2: Cell contains an even number

• Data in B1: 8
• Formula:

  =ISODD(B1)
  

• Result: FALSE (since 8 is an even number).

Example 3: Cell contains a negative odd number

• Data in C1: -3
• Formula:

  =ISODD(C1)
  

• Result: TRUE (since -3 is an odd number).

Example 4: Cell contains a decimal number

• Data in D1: 3.5
• Formula:

  =ISODD(D1)
  

• Result: FALSE (since 3.5 is not an integer and thus not considered an odd number).

Key Points:

1. Odd Numbers: Odd numbers are integers that cannot be evenly divided by 2 (e.g., 1, 3, 5, -1, -3).
2. Even Numbers: Even numbers are integers divisible by 2 (e.g., 2, 4, 6, 8).
3. Negative Numbers: ISODD treats negative odd numbers correctly. For example, -1, -3, and -5 will return TRUE.
4. Non-Integer Numbers: Decimal numbers and non-integer values will return FALSE because they are not considered odd or even numbers in the integer sense.

Use Cases:

1. Conditional Formatting: Use ISODD to apply different formats to odd-numbered rows or cells:

   =ISODD(ROW())  ' Format odd-numbered rows.
   

2. Counting Odd Numbers: Combine ISODD with COUNTIF to count odd numbers in a range:

   =COUNTIF(A1:A10, ">=0")  ' Count positive odd numbers in a range.
   

3. Conditional Logic: Use ISODD in formulas that need to process odd or even numbers differently:

   =IF(ISODD(A1), "Odd", "Even")