ISODD

Returns TRUE if the number is odd, FALSE if even

Syntax

ISODD(number)

Arguments

Argument	Description	Required
number	The number to test for oddness	Required

Examples

Test if 3 is odd

Test if 4 is odd

Use with ROW function

Related Functions

Other Logical functions:

• AND - Returns true if all arguments evaluate to true
• CONTAINS - Returns true if a range contains a specified value
• IF - Returns the first value if logical_expression is TRUE; otherwise returns the second value.
• IFERROR - Returns a custom result when a formula generates an error, and a normal result when no error is detected.
• IFS - Returns the value corresponding to the first TRUE result when evaluating multiple tests.
• ISBETWEEN - Returns true if a provided number is between two other numbers either inclusively or exclusively; otherwise returns false.
• ISBLANK - Returns true if the value is blank, empty, or null; otherwise returns false.
• ISERROR - Returns TRUE if the value is any error value
• ISEVEN - Returns TRUE if the number is even, FALSE if odd
• ISNA - Returns TRUE if the value is the #N/A error value
• ISNUMBER - Returns TRUE if the value is a number
• ISTEXT - Returns TRUE if the value is text
• NOT - Returns FALSE if logical expression is TRUE and TRUE if logical expression is FALSE.
• OR - Returns true if any argument evaluates to true

---

← Back to Formula Reference