EVEN
Rounds a number up to the nearest even integer (away from zero). Useful for paired items, two-by-two grouping, etc.
EVEN(number)Arguments
numberThe number to round to the next even integer.
=EVEN(3)Rounds 3 up to the next even integer
=EVEN(2.5)Rounds 2.5 up to the next even integer
=EVEN(-1)Negatives are rounded away from zero
- •Always rounds away from zero (positive numbers go up, negative numbers go down)
- •Returns 0 if number is 0
- •Use ODD() to round to the nearest odd integer instead
- •Assuming EVEN rounds to the nearest even number - it actually always rounds away from zero to the next even number, regardless of which even number is closer
- •Applying EVEN to a number that's already even, expecting it to stay the same - it does stay the same in that case, but the away-from-zero rounding rule can still surprise people who don't realize EVEN never rounds down for positive numbers
- •Confusing EVEN with ODD - EVEN always rounds to an even number, while ODD always rounds to an odd number, and picking the wrong one for a specific formatting or calculation need is an easy mix-up
ODDAlways rounds away from zero to the next odd number, the direct counterpart to EVEN.ROUNDRounds to the nearest value using standard rounding rules, rather than always targeting an even number like EVEN.CEILINGRounds up to the nearest multiple of a specified significance, a more flexible alternative when a multiple other than 2 is needed.Does EVEN round to the nearest even number?
No, it always rounds away from zero to the next even number, even if a closer even number exists in the other direction. EVEN(3) returns 4, not 2, even though both are technically 'even numbers near 3'.
What does EVEN do with a negative number?
It rounds away from zero, so EVEN(-3) returns -4, following the same away-from-zero rule as positive numbers.
What's the difference between EVEN and ODD?
EVEN always rounds to the nearest even number away from zero, while ODD always rounds to the nearest odd number away from zero.
Need to translate a formula using EVEN?
Use our translator to convert your complete formula