The EVEN, ODD guide
=ODD(4) is 5 and =EVEN(53) is 54. Each rounds up to the next odd or even whole number, and leaves a number that already fits as it is.
The syntax
=EVEN(number)
=ODD(number)
Both take one number. They round away from zero, to a whole number, until it is even (or odd):
| Number | EVEN | ODD |
|---|---|---|
| 4 | 4 | 5 |
| 5 | 6 | 5 |
| 1.5 | 2 | 3 |
| -1 | -2 | -1 |
| 0 | 0 | 1 |
Where they're useful
Anything that comes in pairs. Double-sided printing uses two pages per sheet, so a 53-page document takes EVEN(53) = 54 page sides. Books start chapters on a right-hand page, which always has an odd number: if the last chapter ends on page 16, the next one starts on ODD(17) = 17; if it ends on page 3, the next free page is 4 and the chapter starts on ODD(4) = 5, with page 4 left blank. Seats at tables for two, shoes, gloves and doubles teams work the same way.
EVEN is not ISEVEN
ISEVEN(4) answers a question: TRUE. EVEN(4) returns a number: 4. Use ISEVEN and ISODD in an IF or a filter, EVEN and ODD when you need the rounded number.
Common mistakes
- Adding 1 every time.
C2+B2+1skips a page even when the next page is already odd. ODD only moves it when it has to. - Adding up the chapters. The blank pages between them print too, so the page count comes from the last page used.
- ISODD for a number. It returns TRUE or FALSE.
FAQ
- What does the EVEN function do in Excel?
- EVEN rounds a number up, away from zero, to the nearest even whole number. EVEN(3) is 4 and EVEN(1.2) is 2.
- What is the difference between ODD and ISODD?
- ODD returns a number rounded up to an odd whole number. ISODD returns TRUE or FALSE depending on whether a number is odd.
- What do EVEN and ODD do with negative numbers?
- They round away from zero: EVEN(-1) is -2 and ODD(-2) is -3.
- What is ODD(0) in Excel?
- 1. ODD always rounds up to an odd number, and 0 is even.



































































