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:
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.