Excel ISODD Function

The Excel ISODD function tests if the supplied number or the inputted numeric value I equal to an odd number. The return is TRUE if there is an odd number and False if there is no odd number.

The purpose of the function is to test for an odd number and return a logical value of TRUE or False based on the presence of odd numbers.

Figure 1: Excel ISODD Function


The basic syntax of this function is as follows:

=ISODD (num)

Where “num” is the numeric value to be checked

Use of function

The ISODD function is use to test the presence of odd numbers and then to return that result with a TRUE or FALSE. If there is no numeric value then the #VALUE is shown as return value.

In the above example the cell numbers B6 is returned as FALSE because the number used in the cell is even no and the next cell B7 is turned as TRUE as it is an ODD number respectively. The numbers zero and decimals are also depicted as FALSE.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment