Excel like a finance pro.
← The libraryPractice · 2 questions →
Math function
EVEN
Rounds a number up to the nearest even integer.
Rarely usedDifficulty 1050 · CapableUsage rank #242 of 520
When to use it
Rounds away from zero to the nearest even integer. Used for pairing, two-per-page layouts, and symmetric packaging.
The shape of it
- Syntax
=EVEN(number)
Worked examples
Odd input
=EVEN(3) → 4
Up to the next even.
Fractional input
=EVEN(2.5) → 4
Non-integers round away from zero first.
Negative input
=EVEN(-3) → -4
Away from zero means -4, not -2.
Worth knowing
- Sheets of paper for double-sided printing: =EVEN(pages)/2.
- EVEN(x)=x is a quick even test; ISEVEN is clearer.
- For nearest even in either direction use MROUND(x,2).
Where it goes wrong
- Already-even numbers are unchanged, including 0.
- Rounds away from zero, never toward, so EVEN(2.1) is 4.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.