Quick Navigation
ISODD Function
Summary
The ISODD function determines whether a given number is odd, returning TRUE for odd numbers and FALSE for even numbers. This logical test is essential for pattern-based calculations, conditional formatting, and data analysis tasks requiring parity checks.
Syntax
ISODD(value)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| value | Number |
Yes | Numeric value or reference to check if odd |
Using the ISODD Function
ISODD simplifies parity testing in Excel formulas. Use it to create alternating row patterns, filter odd-numbered records, or apply conditional logic based on number parity without manual modulo calculations.
Common ISODD Examples
Basic Odd Number Test
=ISODD(7)Returns TRUE because 7 is an odd number.
Even Number Test
=ISODD(10)Returns FALSE because 10 is even.
Cell Reference Test
=ISODD(A1)Tests if value in A1 (e.g., 15) is odd, returns TRUE.
Negative Number Test
=ISODD(-3)Returns TRUE as -3 is considered odd.
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: value contains text or cannot be converted to a number
Solution: Ensure input is numeric or use ISNUMBER first to validate
Notes
- Works with positive, negative integers, and zero
- Ignores decimal portion (ISODD(5.9)=TRUE)
- Pairs well with ISEVEN for complete parity testing
- Useful in MOD formulas: ISODD(value)=MOD(value,2)=1
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in:
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+