How to Use the ISEVEN Function in Google Sheets

Published on

The ISEVEN function in Google Sheets is categorized under the math functions. Use this function to check whether a cell contains an even integer, returning TRUE or FALSE based on the value.

You can apply ISEVEN in data analysis and combine it with other functions in formulas. This tutorial explains how to use this simple function.

Syntax

ISEVEN(value)

Here, the argument “value” can be a number or a date. When using a date, it is converted to its serial number, and the function checks if that number is even.

Examples of Using ISEVEN in Google Sheets

The formula below will return TRUE because the number is even:

=ISEVEN(12)

If cell A1 contains 12, you can apply this formula as =ISEVEN(A1).

An odd number will return FALSE, but what about using a date?

My system date today is 26/09/2018. See the formula below:

=ISEVEN(TODAY())

This returns FALSE because the serial number for the provided test date is an odd number.

If you enter the date in a cell and apply Format > Number, it will show 43369, which is an odd number.

Can You Use ISEVEN with an Array or Range?

Yes, ISEVEN can be applied to a range of values. Here’s an example:

=ArrayFormula(ISEVEN(A2:A9))
ISEVEN Function Used in an Array

While ISEVEN is not an array formula itself, you need to combine it with ArrayFormula. However, this is not necessary when using ISEVEN with other array functions like SUMPRODUCT, FILTER, INDEX, SORT, or SORTN.

Note: The ISEVEN function referencing an empty cell will return TRUE since the value in an empty cell is 0. Zero divides evenly by 2 without a remainder, so we consider it even.

Using ISEVEN for Filtering

This formula filters only even numbers in the given range:

=FILTER(A2:A9, ISEVEN(A2:A9))
ISEVEN in Filtering

The FILTER function checks if the condition ISEVEN(A2:A9) is TRUE for the given range.

Applying ISEVEN for Conditional Formatting

Users commonly apply ISEVEN in conditional formatting. You can use it to apply alternating colors to selected rows.

For example, to apply alternating colors in the range A2:Z100:

  1. Select the range and go to Format > Conditional formatting.
  2. Under Format cells if, select Custom formula is and apply this formula:
=ISEVEN(ROW($A2))

Note: Alternating colors can also be applied without a formula via Format > Alternating colors.

Combining ISEVEN with an IF Logical Statement

Test whether a value is even using IF and perform different actions:

=IF(ISEVEN(A1), "even", "odd")

In this formula, you can replace “even” and “odd” with other calculations based on the value in A1.

Practical Applications of ISEVEN in Google Sheets

Here’s an example demonstrating the usefulness of ISEVEN in certain data manipulation tasks.

The data shows the present/absent status of an employee and their overtime hours. Some cells (e.g., C6, C10, and C12) are missing the text “OT,” even though they contain overtime hours.

ROW Function Used with ISEVEN

To filter out the overtime hours, use the following formula:

=FILTER(B3:H12, ISEVEN(ROW(A3:A12)))
Practical Use of the ISEVEN Function

Resources

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Cycle Highlights in Google Sheets – Rotate Highlights Daily

Want to cycle highlights in Google Sheets every day? Whether you're rotating a meal...

Filter Rows Containing Multiple Selected Values in Google Sheets

This tutorial explains how to filter rows in a column containing multiple selected drop-down...

Two-Way Lookup with XLOOKUP in Google Sheets

When you need to look up one search key vertically and another horizontally, you...

How to Filter by Total in Google Sheets Pivot Tables

Google Sheets offers many tools to summarize and analyze data, but Pivot Tables are...

More like this

Cycle Highlights in Google Sheets – Rotate Highlights Daily

Want to cycle highlights in Google Sheets every day? Whether you're rotating a meal...

Filter Rows Containing Multiple Selected Values in Google Sheets

This tutorial explains how to filter rows in a column containing multiple selected drop-down...

Two-Way Lookup with XLOOKUP in Google Sheets

When you need to look up one search key vertically and another horizontally, you...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.