EVEN Function
Rounds a number up to the nearest even whole number.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A whole number
Want to practice EVEN in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
EVEN rounds away from zero to the next even integer: 3 → 4, 4.1 → 6, −1 → −2.
It's useful when items come in pairs — seats at tables for two, double-sided pages.
Syntax
=EVEN(number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The value to round. |
Examples
Example 1 — Pairs of seats
Seats come in pairs; round each booking up.
B2fx=EVEN(A2)
| A | B | |
|---|---|---|
| 1 | Guests | Seats |
| 2 | 3 | 4 |
| 3 | 4 | 4 |
| 4 | 7 | 8 |
=EVEN(A2) Explain
Common mistakes
- Always away from zero. EVEN(0.1) is 2, not 0.
Notes
- Related functions: ODD, ISEVEN, CEILING.MATH.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.