ISODD Function

Summary

ISODD returns TRUE when a number is odd and FALSE when it is not. Like ISEVEN, it is often used in formatting patterns, simple grouping rules, and cycle checks.

The decimal rule is the same here too. Excel truncates the decimal part before checking, so 11.9 is treated as 11.

ISODD is useful for rule-based logic where odd values need their own branch. That can include alternating patterns, schedule grouping, or formulas that use parity to decide which action, label, or formatting rule should apply.

Syntax

=ISODD(number)

You can use a number, a formula, or a cell reference.

Arguments

• number - [required] The value you want to test for odd parity.

ISODD vs Other Functions

Using ISODD

This function is useful when odd values need special treatment. It works well in alternating layouts, audit sampling, and simple A/B style logic where odd-numbered items go one way and even-numbered items go another.

It is also worth remembering that zero returns FALSE here because zero is even, not odd.

Example 1 - Check odd row numbers

This is a simple layout pattern. When ROW() returns an odd row number, ISODD returns TRUE, so the formula is often used in alternating layouts.

That makes the example practical right away. It helps the sheet identify odd-numbered rows for formatting or row-based rules.

=ISODD(ROW())

Example 2 - See the truncation rule

Decimals are truncated before parity is checked. So 11.9 is treated as 11, which is why the result is TRUE.

This matters because Excel is not rounding here. The example shows that the decimal part is removed first, then the odd-even check happens.

=ISODD(11.9) // Returns TRUE because Excel checks 11.

Example 3 - Check a negative odd value

Negative odd integers still return TRUE. A value like -3 is still odd, so the sign does not change the parity result.

This helps the learner keep the rule simple: odd is still odd, even when the number is negative.

=ISODD(-3) // Returns TRUE.

Example 4 - Use it for a split rule

This keeps an odd-even split readable. If the value in B1 is odd, the formula sends it to "Audit Required". Otherwise it goes to "Standard Path".

That makes ISODD useful beyond formatting. It can also drive simple workflow decisions based on odd-numbered IDs, cycles, or batches.

=IF(ISODD(B1),"Audit Required","Standard Path")

Conclusion Recap

ISODD is a simple check, but it becomes useful fast when a sheet needs odd-number logic. In this lesson, that showed up in row patterns, ID-based split rules, and cases where odd values need a different action from even ones.

The main thing to remember is that Excel removes the decimal part first, and zero does not count as odd. Once that is clear, the result is easy to read.

• Main job: ISODD checks whether a number is odd.
• Decimal rule: Excel truncates before checking.
• Zero: It returns FALSE because zero is even.
• Good uses: Layout logic, sampling rules, and grouping patterns.