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.
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))))
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.