All in One Bundle

EVEN Function In Google Sheets

Written by ExcelMojo Team ExcelMojo Editorial Team Editorial Team The ExcelMojo Editorial Team creates and improves practical Excel, VBA, Power BI, analytics, and AI spreadsheet resources for learners, analysts, teams, and business professionals. Excel VBA Power BI View Full Bio
Reviewed by Dheeraj Vaidya, CFA, FRM Dheeraj Vaidya, CFA, FRM Co-Founder & Course Director Dheeraj is the founder of ExcelMojo and leads the learning direction across Excel, analytics, financial modeling, valuation, and AI spreadsheet workflows. A former J.P. Morgan and CLSA equity... Financial Modeling Valuation Investment Banking View Full Bio
Updated Apr 23, 2026
Read Time 7 min

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.

EVEN function in Google sheets Definition 1

Now, we need to convert the odd number into the nearest even integer value using EVEN function.

Download FREE EVEN Function In Google Sheets Template and Follow Along!

Use this EVEN Function In Google Sheets Template to follow along with the examples in this article.

Download Excel Template

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.

EVEN function in Google sheets Definition 1-1

In this article, let us learn about EVEN function with detailed examples.

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

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.

EVEN With Positive Numbers Example 1

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.

EVEN With Positive Numbers Example 1-1

Now, using AutoFill option, we can find the result in other cells B3:B7, as shown in the below image.

EVEN With Positive Numbers Example 1-2

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.

EVEN With Negative Numbers Example 2

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)

EVEN With Negative Numbers Example 2-1

Step 3: Press Enter key.

We will be able to see the result in cell B2, as shown in the below image.

EVEN With Negative Numbers Example 2-2

Now, using AutoFill option, we can find the result in other cells B3:B7, as shown in the below image.

EVEN With Negative Numbers Example 2-3

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.

EVEN function in Google sheets Example 3

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)

EVEN function in Google sheets Example 3-1

Step 3: Press Enter key.

We will be able to see the result in cell B2, as shown in the below image.

EVEN function in Google sheets Example 3-2

Now, using AutoFill option, we can find the result in other cells B3:B7, as shown in the below image.

EVEN function in Google sheets Example 3-3

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

1) Explain the use of EVEN function in Google sheets with an example.

For example, consider the below table showing a number in cell A2.
EVEN function in Google sheets FAQ 1
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.
EVEN function in Google sheets FAQ 1-1
Likewise, we can use the EVEN function.

2) What is the difference between EVEN and ISEVEN function in Google sheets?

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.

3) Why EVEN function does not work in the Google spreadsheets?

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 FREE EVEN Function In Google Sheets Template and Follow Along!

Use this EVEN Function In Google Sheets Template to follow along with the examples in this article.

Download Excel Template