How to Use ISEVEN Function in Google Sheets [Formula Examples]

Published on

The ISEVEN function in Google Sheets is categorized under the math function. Use this function to check the presence of even integer values in cells. It returns TRUE or FALSE based on the test value.

ISEVEN is effective in data analysis and can be part of combination formulas. In this Google Spreadsheet tutorial, I am explaining this simple function.

Syntax:

ISEVEN(value)

Here the argument value can be date or number. When you use a date, the date value will be taken into account.

Examples of the Use of ISEVEN Function in Google Sheets

The below ISEVEN formula will return TRUE since the number is even.

=ISEVEN(12)

Needless to say, an odd number as the value will result FALSE. What about the use of a date in the ISEVEN function in Google Sheets?

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

=ISEVEN(TODAY())

This formula returns FALSE simply because of the date value of the provided test date, which is an odd number.

=DATEVALUE(TODAY())

Result: 43369

You May Like: Learn All Popular Date Functions in Google Sheets.

How to Use ISEVEN Function in an Array

No doubt, you can use the ISEVEN with a range of values. The below example shows the same.

ISEVEN Function in an Array

The ISEVEN function itself is not an array formula. So it’s a must to use the function ArrayFormula with it. But there is an exception to this rule.

If you use the function ISEVEN with any array functions, then the above rule is not relevant. The ISEVEN together with Filter is the best example of this.

How to get even numbers as output instead of TRUE or FALSE? See the answer under the title below.

The Use of ISEVEN in Filtering

In the following example, the Filter formula filters only the even numbers in the given range.

ISEVEN in Filtering

ISEVEN in Conditional Formatting

It’s one of the functions that is famously being used in conditional formatting. You can use an ISEVEN formula to get alternating colors in the selected rows.

You May Also Like: How to Conditional Format Duplicates Across Sheet Tabs in Google Sheets.

Note: Actually, you can easily apply the same setting without formula from Format > Alternating colors.

Example:

I want to apply alternating color in the range A3: A12. How to do that?

Select the range A3: A12 and go to the menu Format > Conditional formatting and apply the below formula rule.

ISEVEN in Conditional Formatting

Tip: The Zero is an even number!

How to Use Iseven with IF Logical Statement

You can test a value whether it’s even with IF and perform do this or do that based on it.

=if(iseven(A1),"even","odd")

In this, you can replace the test strings “even” or “odd” with other calculations. The calculation will be done based on the value in A1.

Must Read: Combined Use of IF, AND, OR Logical Functions.

Practical Use of the ISEVEN Function in Google Sheets

The below example shows how useful is the ISEVEN function in Google Sheets in certain data manipulation techniques.

Here is part of an attendance sheet, which is not formatted correctly.

Row Function with ISEVEN

This data shows the present/absent status of an employee and his overtime hours. In this, how to filter all the number which is overtime hours?

You can see that cell C6, C10, and C12 which are missing the text “OT” even though that rows contain the overtime hours.

This data is not formatted well so it’s tough to apply a filter using the criterion “OT”. But you can use the filter formula as below.

Formula:

=ArrayFormula(filter(B3:H12,iseven(row(A3:H12))))

Result:

Practical use of ISEVEN Function

That’s all about how to use the ISEVEN function in Google Sheets.

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.

Highlight Upcoming Birthdays in Google Sheets

When highlighting upcoming birthdays in Google Sheets, one important aspect is ignoring the year...

Compare Two Tables for Differences in Excel

To compare two tables with similar data for differences, you can use the XLOOKUP...

Calculate Weighted Average in Pivot Table in Google Sheets

You can calculate a weighted average in a Pivot Table using a custom formula...

Summarize Data and Keep the Last Record in Google Sheets

In Google Sheets, we can summarize data (like sum, average, min, max, count) using...

More like this

Highlight Upcoming Birthdays in Google Sheets

When highlighting upcoming birthdays in Google Sheets, one important aspect is ignoring the year...

Calculate Weighted Average in Pivot Table in Google Sheets

You can calculate a weighted average in a Pivot Table using a custom formula...

Summarize Data and Keep the Last Record in Google Sheets

In Google Sheets, we can summarize data (like sum, average, min, max, count) using...

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.