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

Join Office for Mere Mortals today

Office for Mere Mortals is where thousands pick up useful tips and tricks for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  We've never spammed or sold addresses since we started over twenty years ago.