EVEN rounds a number up to the next even integer; ODD rounds up to the next odd one. Handy for packaging in pairs, two-sided printing, or any quantity that must land on an even or odd count.
The example
3 rounds up to even 4; 4 to odd 5.
| A | B | |
|---|---|---|
| 1 | Value | EVEN / ODD |
| 2 | 3 | 4 / 3 |
| 3 | 4 | 4 / 5 |
The formula
The formula:
How it works
How it works:
EVEN(value)rounds up to the nearest even integer — 2.1 and 3 both become 4.ODD(value)rounds up to the nearest odd integer — 2 and 2.1 both become 3.- Both round away from zero, so negatives go more negative (EVEN(-1.5) = -2).
- Use them for things that come in pairs (EVEN) or need a center (ODD), like seats, sheets, or panel counts.
Don’t confuse with ISEVEN/ISODD. EVEN/ODD round a number to an even/odd integer; ISEVEN/ISODD test whether a whole number is even or odd and return TRUE/FALSE. Different jobs entirely.
Try it: interactive demo
Enter a value.
Variations
Test even/odd
TRUE/FALSE:
Round to nearest even
Banker’s style:
Next multiple of 2
Same as EVEN for positives:
Pitfalls & errors
Always rounds up. EVEN/ODD round away from zero, never down — 4.0 stays 4 but 4.1 jumps to 6 for EVEN.
Not a parity test. For TRUE/FALSE use ISEVEN/ISODD instead.
Negatives go outward. EVEN(-1.5) = -2, not 0.
Practice workbook
Frequently asked questions
How do I round up to the next even number in Excel?
What's the difference from ISEVEN?
How do EVEN and ODD handle negatives?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class