The ISEVEN function

The ISEVEN function is an information function which will return either TRUE or FALSE if the selected cell or values result in an even integer value or not.

This is the format of the ISEVEN function:

=ISEVEN(REFERENCE OR FORMULA)

Here is an example of the ISEVEN function:

=ISEVEN(5) = FALSE

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 ISEVEN 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 ISEVEN function you can easily switch between two formulas needed to manipulate the data by referencing those cells across your range.

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

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