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()`