What Is EVEN Function In Google Sheets?
EVEN function in Google sheets, as the name suggests, is an inbuilt function used to convert odd numbers into the nearest even integer number. It is available both in Excel and Google sheets. Users can use EVEN function when they want to round up values into even integers. This function is available under the Math functions in Google Sheets.
For example, consider the below table showing a number in cell A2.
Now, we need to convert the odd number into the nearest even integer value using EVEN function.
To begin with, we need to insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:B2. Next, we need to select the cell where we want to find the result. In this example, we need to select the cell B2. Next, insert the EVEN function in cell B2. So, the complete formula is =EVEN(A2). Press Enter key.
We will be able to see the result in cell B2, as shown in the below image.
In this article, let us learn about EVEN function with detailed examples.
Table of Contents
Key Takeaways
- EVEN function in Google sheets is a default function used to convert odd numbers into even numbers.
- The syntax of EVEN function in Google sheets is =EVEN(value) where value is the argument showing the numeric value in the cell.
- The EVEN function in Google sheets is available under the Math functions in the Formulas tab.
- Remember, this function only works if the data contains numeric values. With non-numeric values, users might get an error.
- The function converts both positive and negative odd numbers into the nearest integer in Google sheets.
EVEN() Google Sheets Formula
The formula or syntax of EVEN Google sheets function in =EVEN(value)
where,
- Value is the argument showing the cell with the numeric value.
How To Use EVEN Function In Google Sheets?
We can use EVEN function in Google sheets with the help of the following steps.
The steps are:
Step 1: To begin with, we need to insert the cell range in the spreadsheet. Next, we need to select the cell where we want to find the result.
Step 2: Next, insert the EVEN function in cell B2.
Step 3: Press Enter key.
We will be able to see the result in the active cell.
Likewise, we can use the EVEN function.
Examples
Example #1 – EVEN With Positive Numbers
For example, consider the below table showing positive values in column A in the cell range A1:A7.
Now, we need to convert the odd positive numbers into the nearest even integer value using EVEN function.
The steps are:
Step 1: To begin with, we need to insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:B7. Next, we need to select the cell where we want to find the result. In this example, we need to select the cell B2.
Step 2: Next, insert the EVEN function in cell B2.
So, the complete formula is =EVEN(A2)
Step 3: Press Enter key.
We will be able to see the result in cell B2, as shown in the below image.
Now, using AutoFill option, we can find the result in other cells B3:B7, as shown in the below image.
Likewise, we can use the EVEN function to convert positive numbers into even numbers.
Example #2 – EVEN With Negative Numbers
For example, consider the below table showing negative values in column A in the cell range A1:A7.
Now, we need to convert the odd negative numbers into the nearest even integer value using EVEN function in Google sheets.
The steps are:
Step 1: To begin with, we need to insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:B7. Next, we need to select the cell where we want to find the result. In this example, we need to select the cell B2.
Step 2: Next, insert the EVEN function in Google sheets in cell B2.
So, the complete formula is =EVEN(A2)
Step 3: Press Enter key.
We will be able to see the result in cell B2, as shown in the below image.
Now, using AutoFill option, we can find the result in other cells B3:B7, as shown in the below image.
Likewise, we can use the EVEN function to convert negative numbers into even numbers.
Example #3
For example, consider the below table showing mixed values (both positive and negative) in column A in the cell range A1:A7.
Now, we need to convert the odd numbers into the nearest even integer value using EVEN function.
The steps are:
Step 1: To begin with, we need to insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:B7. Next, we need to select the cell where we want to find the result. In this example, we need to select the cell B2.
Step 2: Next, insert the EVEN function in cell B2.
So, the complete formula is =EVEN(A2)
Step 3: Press Enter key.
We will be able to see the result in cell B2, as shown in the below image.
Now, using AutoFill option, we can find the result in other cells B3:B7, as shown in the below image.
Likewise, we can use the EVEN function to convert positive and negative numbers into even numbers.
Common Errors
Some of the common errors users can do while using EVEN function in Google sheets are:
- EVEN function in Google sheets does not work if the data contains non-numeric values such as text, punctuation marks or other symbols.
- Similarly, the function may not work if the syntax or formula is not specified correctly
Important Things To Note
- EVEN function in Google sheets is an inbuilt function used to get the rounded value of a number with nearest integer.
- We need to remember to select the cell value in the place of argument to avoid errors.
- Make sure to have only numeric values in the data while using EVEN function in Google sheets.
Frequently Asked Questions
For example, consider the below table showing a number in cell A2.
Now, we need to convert the odd number into the nearest even integer value using EVEN function.
The steps are:
Step 1: To begin with, we need to insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:B2. Next, we need to select the cell where we want to find the result. In this example, we need to select the cell B2.
Step 2: Next, insert the EVEN function in Google sheets in cell B2.
So, the complete formula is
Step 3: Press Enter key.
We will be able to see the result in cell B2, as shown in the below image.
Likewise, we can use the EVEN function.
The difference between EVEN and ISEVEN functions in Google sheets are:
• EVEN function converts odd numbers into even numbers
• ISEVEN function checks if the value is even or not.
As already discussed, EVEN function in Google sheets may not work if there are any non-numeric values in the data. So, we need to avoid using text, symbols, punctuation marks or other non-numeric values in the data while using EVEN function.
Download Template
This article must help understand EVEN Function In Google Sheets with its formulas and examples. You can download the template here to use it instantly.
Recommended Articles
Guide to What is EVEN Function In Google Sheets. Here we discuss how to use EVEN Function In Google Sheets with its examples. You can learn more from the following articles. –
COUNT FUNCTION IN GOOGLE SHEETS
Leave a Reply