The EVEN function returns number rounded up to the nearest even integer.




Argument Description
number The numeric value that you want to round

Note: The EVEN function rounds a supplied number away from zero, i.e. rounds a positive number up and a negative number down, to the next even number.


  A B C
1 Formula Result Notes
2 =EVEN(2.2) 4 Rounds 2.2 to the nearest even integer
3 =EVEN(-2.2) -4 Rounds -2.2 to the nearest even integer
4 =EVEN(5) 6  
5 =EVEN(2) 2