Rounds a number up to the nearest even integer.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
EVEN(number)The EVEN function rounds a positive number up and a negative number down to the nearest even integer. If the number is already an even integer, no rounding occurs.
=EVEN(1.5)Result: 2
Rounds 1.5 up to the nearest even integer, which is 2.
=EVEN(-3)Result: -4
Rounds -3 away from zero to the nearest even integer, which is -4.
No, it rounds away from zero to the next even integer.