Exceljet

Quick, clean, and to the point

Excel ISODD Function

Excel ISODD function
Summary 

The Excel ISODD function returns TRUE when a numeric value is odd, and FALSE for even numbers. ISODD will return the #VALUE error when a value is not numeric.

Purpose 
Test if a value is odd
Return value 
A logical value (TRUE or FALSE)
Syntax 
=ISODD (value)
Arguments 
  • value - The numeric value to check.
Usage notes 

Use the ISODD function to check if a numeric value is an odd number. ISODD will return TRUE when a numeric value is odd and FALSE when a numeric value is even. If value is not numeric, ISODD will return the #VALUE error.

For example, =ISODD(A1) will return TRUE if A1 contains the number 3 and FALSE if A1 contains the number 4.

Usually, value is supplied as a cell address.

ISODD is part of a group of functions called the IS functions that all return the logical values TRUE or FALSE.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.