Excel function · Statistics
EVEN
Rounds a number up to the next even whole number.
What it does
EVEN rounds a number away from zero to the nearest even whole number: 23 becomes 24, 2.1 becomes 4, -1 becomes -2. An even whole number stays as it is. It suits things that come in pairs.
Syntax
=EVEN(number)Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ,
Arguments
- number
- The number to round.
Example
23 guests sit at tables for two. How many seats are needed?
| A | B | |
|---|---|---|
| 1 | Guests | Seats (tables for 2) |
| 2 | 23 | 24 |
The formula in B2:
=EVEN(A2)Result: 24
23 is odd, so it is rounded up to the next even number: 24 seats, 12 tables.
Common mistakes
- Expecting it to round to the nearest even number. It always rounds up (away from zero): 22.1 becomes 24, not 22.
- Using it to test whether a number is even. Use
MOD(A2,2)=0for that.
In other Excel languages
Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.
| Excel language | Function name | Separator |
|---|---|---|
| English | EVEN | , |
| Deutsch | GERADE | ; |
| Français | PAIR | ; |
| Español (España) | REDONDEA.PAR | ; |
| Español (México) | REDONDEA.PAR | , |
| 日本語 | EVEN | , |
| 한국어 | EVEN | , |
| 繁體中文 | EVEN | , |
| ไทย | EVEN | , |
| ខ្មែរ | EVEN | , |
| Tiếng Việt | EVEN | ; |