EVEN() and ODD() are yet more ways to round numbers in Excel 

Excel has two functions that round numbers to either the next Even or Odd numbers – these functions are called … wait for it … Even() and Odd()! 

Both Odd() and Even() round positive numbers UP to the next odd/even number.  Negative numbers are always rounded DOWN to the next lowest odd/even negative number. In other words, the two functions always round AWAY from Zero. 

Even() basics

Only one parameter for Even(), the number to round. 

Even(number) 

Number – any number you want rounded. 

Even() in action

Even() always rounds AWAY from zero to the next even integer. 

Zero itself is an even number (at least in Excel World™) so Even(0) = 0 

Odd() basics

Only one parameter for Odd(), the number to round. 

Odd(number) 

Number – any number you want rounded. 

Odd() in action

Odd() always rounds AWAY from zero to the next odd number. 

Zero itself is an even number (at least in Excel World™) so Odd(0)=1 … a result that might not be expected or wanted. 

IsEven() and IsOdd()

Since we’re talking about even and odd numbers, a reminder that there’s also two ‘If’ tests to check if an integer is even or odd. Check out IsEven() and IsOdd()

All about MROUND() in Excel  
All about Ceiling() and Floor()  Excel rounding options 
Excel’s Round () and NINE other rounding functions 
The important difference between Int() and Trunc() in Excel