Purpose
Return value
Syntax
=ISODD(value)- value - The numeric value to check.
How to use
The ISODD function tests for odd numbers. ISODD takes one argument, value, which should be a numeric value or a cell reference. When value is an odd number, ISODD returns TRUE. When value is an even number, ISODD returns FALSE. If value is not numeric, ISODD will return the #VALUE error. Only the integer portion of value is evaluated, decimal values are truncated.
Examples
The ISODD function returns TRUE or FALSE:
=ISODD(4) // returns FALSE
=ISODD(3) // returns TRUE
=ISODD(0) // returns FALSE
If cell A1 contains 11, the formula below returns TRUE:
=ISODD(A1) //returns TRUE
Only the integer portion of value is tested. If value is a decimal number, the decimal portion is truncated:
=ISODD(4.1) // returns FALSE
=ISODD(0.33) // returns FALSE
=ISODD(7.4) // returns TRUE
Notes
- If value is not numeric, ISODD will return the #VALUE error.
- Only the integer portion of value is tested; decimal values are truncated.
- Use the ISEVEN function to test for even numbers.
ISODD function examples
Highlight every other row
Shade alternating groups of n rows
Count cells that contain odd numbers
ISODD function videos
Shade groups of rows with conditional formatting
How to create zebra stripes with conditional formatting
How to use a formula with conditional formatting
How to apply conditional formatting with a formula
How to test a conditional formatting formula
Related functions
ISEVEN Function
The Excel ISEVEN function returns TRUE when a value is an even number, and FALSE when a value is an odd number. ISEVEN will return the #VALUE error if a value is not numeric.
ISBLANK Function
The Excel ISBLANK function returns TRUE when a cell is empty, and FALSE when a cell is not empty. For example, if A1 contains "apple", ISBLANK(A1) returns FALSE.
ISERR Function
The Excel ISERR function returns TRUE for any error type except the #N/A error. You can use the ISERR function together with the IF function to test for an error and display a custom message, or perform a different calculation if found.
ISERROR Function
The Excel ISERROR function returns TRUE for any error type excel generates, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! You can use ISERROR together with the IF function to test for errors and display a custom message, or run a different calculation when an error occurs....
ISLOGICAL Function
The Excel ISLOGICAL function returns TRUE when a cell contains the logical values TRUE or FALSE, and returns FALSE for cells that contain any other value, including empty cells.
ISNA Function
The Excel ISNA function returns TRUE when a cell contains the #N/A error and FALSE for any other value, or any other error type. You can use the ISNA function with the IF function test for #N/A and display a friendly message if the error occurs.
ISFORMULA Function
The Excel ISFORMULA function returns TRUE if a cell contains a formula, and FALSE if not. When a cell contains a formula ISFORMULA will return TRUE regardless of the formula's output or error conditions.
ISNONTEXT Function
The Excel ISNONTEXT function returns TRUE when a cell contains any value except text. This includes numbers, dates, times, errors, and formulas that do not return text. ISNONTEXT also returns TRUE when a cell is empty.
ISNUMBER Function
The Excel ISNUMBER function returns TRUE when a cell contains a number, and FALSE if not. You can use ISNUMBER to check that a cell contains a numeric value, or that the result of another function is a number.
ISREF Function
The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not. You can use the ISREF function to check for a reference in a formula.
ISTEXT Function
The Excel ISTEXT function returns TRUE when a cell contains a text value, and FALSE if the cell contains any other value. You can use the ISTEXT function to check if a cell contains a text value, or a numeric value entered as text.
