What Is ISEVEN In Google Sheets?
The ISEVEN in Google Sheets identifies the even numbers in a selected dataset and returns TRUE if found, else returns FALSE and is useful to filter or sort values in a large data. The Google Sheets ISEVEN detects an even number as a cell value, reference or the result of a formula while performing mathematical calculations.
For example, we will determine if the numbers are even values and display the result as logical values, TRUE or FALSE. The table below contains a list of numbers.
Select cell B2, enter the formula =ISEVEN(A2), press “Enter” and drag the formula from cell B2 to B7 using the fill handle.
The output is shown above. Column C is for our reference to understand the formula series. In cell B2, the formula checks whether the cell A2 value, 100, is even or not. It returns TRUE, as the number 100 is an even number. In the case of the cell B6, the specified value, 2.253, gets truncated to 2. And as the truncated value is even, the function returns TRUE as the output.
Table of contents
Key Takeaways
- The ISEVEN in Google Sheets determines if the specified number is even. It always returns a logical value as output, with its return value being TRUE if the given value is even. And the function output is FALSE if the specified number is odd.
- We can use the function with other Google Sheets functions such as IF(), and SUM() and also use the Conditional Formatting method.
- If the specified value is a fraction, first, the Google Sheets converts it into a decimal, truncates it, checks whether the truncated value is even and returns the appropriate logical value.
ISEVEN() Google Sheets Formula
The syntax of the ISEVEN Google Sheets formula is,
The mandatory argument of the ISEVEN Google Sheets formula is,
- value: The dataset to test whether the numeric values are even.
How To Use ISEVEN In Google Sheets?
We can use the ISEVEN In Google Sheets in 2 ways, namely,
- Access from the Google Sheets ribbon.
- Enter in the worksheet manually.
Method #1 – Access from the Google Sheets ribbon –
Choose an empty cell for the output à select the “Insert” tab à click the “Function” option right arrow-click the “Math” option right arrow-select the “ISEVEN” function, as shown below.
The “ISEVEN” formulaappears, as shown below. Enter the argument as the cell reference.
Method #2 – Enter in the worksheet manually –
- Select an empty cell for the output.
- Type =ISEVEN( in the cell. [Alternatively, type =I or =IS and double-click the ISEVEN function from the Google Sheets suggestions.]
- Enter the arguments as cell values or cell references and close the brackets.
- Press Enter to view the outcome.
Examples
We will understand some advanced scenarios using the ISEVEN In Google Sheets examples.
Example #1
We will determine if the dataset contains even values using ISEVEN function.
The table below shows a list of data values and their descriptions.
The steps to find the even numbers using ISEVEN() are,
Step 1: Select cell C2 and enter the formula =ISEVEN(A2).
Step 2: Press the Enter. The result is “TRUE”, as shown below.
[Note: We can use alternate formulas such as =ISEVEN(28) or =ISEVEN(“28”) in the target cells to get the same results.]
Step 3: Drag the formula from cell C2 to C8 using the fill handle. The output is shown below.
[Output Observation:
- In row 2, the specified value is an integer. And as it is even, the function output is TRUE.
- In the case of row 3, the specified argument value is an empty cell. The function evaluates it as 0 and returns TRUE as the outcome.
- Cell A4 contains a date, which represents the serial number 45598. And as the serial number is even, the function return value is TRUE.
- On the other hand, cells A5:A6 contain decimals. So, the function in the corresponding target cells C5 and C6 truncate the decimal values to 3 and 254, respectively. And as the truncated values are odd and even, the function outputs in the corresponding target cells are FALSE and TRUE, respectively.
- In the case of row 7, the specified value is a negative integer. However, it is even. And hence, the function output is TRUE.
- Finally, cell A8 contains the scientific notation of the integer 50. Again, as the integer 50 is even, the function returns TRUE as the output.]
Example #2
We will determine if packing the total stock (in each row) in units of 2 is feasible, and summing the day-wise stock in each row using the and use the ISEVEN function.
The below table contains the five days’ stock details of five items.
The steps to find the even numbers using ISEVEN() and SUM() functions are,
Step 1: Select the target cell G2, enter the formula =ISEVEN(SUM(B2:F2)) and press Enter. The result is ‘False’, as shown below.
Step 2: Drag the formula from cell G2 to G6 using the fill handle. The output is shown below.
[Output Observation:
- In cell G1, first, the SUM() returns the day 1 to day 5 stock total of 153. Next, the ISEVEN function checks whether the total stock value is even. And as 153 is odd, the ISEVEN() returns FALSE as the status.
- In the case of row 5, the total stock is 0, and as it is even, the ISEVEN function returns TRUE in cell G5.]
Example #3
We must split the employees into teams A and B, according to the employee IDs using the ISEVEN() and the IF() functions.
The below table contains a list of employees and their employee IDs.
The steps to find the even numbers using ISEVEN() and IF() functions are,
Step 1: Select cell C2, enter the formula =IF(ISEVEN(A2),”Team A”,”Team B”) and press Enter. The result is “Team A”, as shown below.
Step 2: Drag the formula from cell C2 to C11 using the fill handle. The output is shown below.
[Output Observation: In cell C11, first, the ISEVEN function checks if the specified employee ID, 1739, is even. And as the value is odd, the function returns FALSE.
Next, as the IF condition is FALSE, it returns the FALSE value, Team B, as the allotted team for the employee, John Adams.]
Example #4
In the given dataset, we have two categories, with each category in alternate cells. We will highlight the alternate rows of data to show the categories distinctively using the ISEVEN In Google Sheets and the Conditional Formatting.
The following table shows US’s leading laptop and smartphone models.
The steps to find the even numbers using ISEVEN() and Conditional Formatting are,
Step 1: Choose the cell range A3:B12 – select the “Format” tab – click the “Conditional formatting” option. The “Conditional format rules” pane appears on the right, as shown below.
Step 2: In the “Conditional format rules” pane, click the “Single Color” tab. Under the “Format rules” group,
- Select the “Custom formula” option from the “Format cells if…” drop-down and enter the formula “=ISEVEN(ROW(A3))” in the empty field that appears below.
- Select the desired color from the “Formatting style” options, as shown below.
Step 3: Finally, select the “Done” option to get the following output.
[Output Observation: First, the ROW() returns the row number of the specified cell. And then, the ISEVEN function checks if the row number the ROW() returns is even.
As the conditional formatting rule applies to the cell range A3:B12, each cell gets checked for an even row number. And those cells for which the ISEVEN function returns TRUE, the cell gets highlighted in the chosen color.]
Important Things To Note
- The ISEVEN In Google Sheets argument value can be the specified number, with or without the double quotations or the cell reference to the number in question.
- For a non-numeric argument value, the ISEVEN function throws the #VALUE! error.
- If the selected value is a blank or an empty cell, the formula by default considers it as 0. And as 0 is an even number, then the output is returned as TRUE.
Frequently Asked Questions (FAQs)
We often forget in which category a function falls, here, the “ISEVEN” function. Then, we can insert the function as follows:
Choose an empty cell – select the “Insert” tab – click the “Function” option right arrow – click the “All” option right arrow -select the “ISEVEN” function, as shown below.
However, as always, entering the function manually is the best way to avoid confusion.
Alternatively, we can find the Functions icon to insert the ISEVEN function by following the path shown below.
• Choose an empty cell – click the “More” option represented by the three vertical dots at the end of the toolbar, as shown below.
• A list of icons appears when we click the “More” option. Here, click the “Functions” icon, as shown below.
• Here, click the “Functions” option – click the “All” option right arrow – select the “ISEVEN” function, as shown below.
The ISEVEN may not work due to the following reasons.
• The supplied argument value is non-numeric.
• We executed the function as an array formula.
Download Template
This article must help understand the ISEVEN in Google Sheets, with its formula and examples. We can download the template here to use it instantly.
Recommended Articles
Guide to ISEVEN In Google Sheets. Here, we use formula to see if values or calculated results are even or not, examples and working template. You can learn more from the following articles. –Reader Interactions
Leave a Reply