The ISODD function

The ISODD function is an information function which will return either TRUE or FALSE if the selected cell or values results in an odd integer. Decimal values are not considered when determining if an integer is odd or not.

This is the format of the ISODD function:

=ISODD(REFERENCE OR FORMULA)

Here is an example of the ISODD function:

=ISODD(4) = FALSE
ISODD returning TRUE when evaluating a cell which contains an odd number

ISODD returning TRUE when evaluating a cell which contains an odd number

This function is valuable when a variable such as row number is used to determine what type of output is expected. Partnering with an IF statement can enable users to switch between two formulas depending on the result of the ISODD statement.

An example of a functional implementation of this would be if you are restructuring the data which was used in an old report in order to use it for a bigger analysis, but it is poorly formatted. Even numbered rows have raw data inputs in them, and odd numbered rows have totals and subtotals in them. Using the ISODD function you can easily switch between two formulas needed to manipulate the data by referencing those cells across your range.

=IF(ISODD(ROW()), FORMULA 1, FORMULA 2)

* Note this example uses a combination of IF, ISODD, and ROW to generate an impactful and efficient formula. For more information on these functions please visit their dedicated function pages. *