How to Use EVEN Function in Google Sheets

Published on

EVEN is one of the math functions in Google Sheets. You can use the EVEN function in Google Sheets to round numbers but to the even numbers. Learn here all about the EVEN function in Google Sheets.

Learn Google Sheets Round Functions: ROUND, MROUND, FLOOR, and CEILING.

The purpose of EVEN function in Google Sheets is to round a given number to its next greatest even number. It works equally well with negative as well as positive numbers.

Syntax and Usage of EVEN Function in Google Sheets

Syntax:

EVEN(value)

Basic Examples:

EVEN with Positive Numbers

See the output of EVEN formulas when the values are positive numbers.

EVEN formula with Positive Numbers

The even formulas round the numbers in column A to the next greatest even numbers.

The function EVEN is not an array formula by default. But it supports the function ArrayFormula.

So when you want to round multiple numbers to its next greatest even numbers, you can use a single ArrayFormula as below.

=ArrayFormula(EVEN(A2:A6))

This formula replaces all the formulas in the above example.

If the value is already an even number, the EVEN formula in Google Sheets would return the same value.

Example:

=EVEN(26)

Result: 26

=EVEN(26.4)

Result: 28

If the value is zero, the output would be 0.

Similar Reading: Round, Round Up, Round Down Hour, Minute, Second in Google Sheets.

EVEN with Negative Numbers

When you use negative numbers in EVEN, the numbers will be rounded down to the next negative even number with greater absolute value.

Absolute value means how far a number is from zero. Here are few formula examples with negative numbers in EVEN.

=EVEN(-5)

Result: -6

=EVEN(-9.25)

Result: -10

That is all you want to know about the EVEN function in Google Sheets. Now here is one practical or you can say the tricky use of EVEN function.

I want to populate 20 even numbers in sequential like 2, 4, 6, 8… 20. How to do that?

The function that generates a set of sequential numbers is ROW. But the numbers would be like 1, 2, 3…20.

Here is the EVEN + ROW combination the works as desired.

=ArrayFormula(unique(even(row(A1:A20))))

populate even numbers in Google Doc Sheets

In concise, you can use the function EVEN to convert a single or set of odd numbers to even.

That’s all about the EVEN 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.

Hierarchical Numbering Sequences in Excel

Creating hierarchical numbering sequences in an Excel spreadsheet can significantly improve the way you...

How to Easily Repeat a Sequence of Numbers in Excel

Excel offers multiple ways to accomplish tasks, and the simplicity of each approach depends...

Create a Sequence of Dates at Every Nth Row in Excel (Dynamic Array)

Would you like to create a sequence of dates in every nth row in...

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

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.