Math & Trig
EVEN Function in Excel
Rounds a number up to the nearest even integer.
Syntax
- =EVEN(number)
Arguments
- number (required): Number to round
Examples
- =EVEN(1.5) - Round up to even - Result: 2
- =EVEN(3) - Round 3 up to even - Result: 4
EVEN in reporting workflows
- Use absolute references when copying formulas across rows.
- For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
- Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.
Common errors
- Rounds away from zero for negatives
Use cases
- Pairing items
- Rounding
- Inventory
Frequently asked questions
- What is EVEN used for in Excel? EVEN rounds numbers UP to the nearest even integer. EVEN(1.5)=2, EVEN(3)=4, EVEN(4)=4. Useful for pairing items, ensuring even quantities, or rounding to multiples of 2 (always rounding up).
- How does EVEN handle negative numbers? EVEN rounds away from zero for negatives: EVEN(-1.5)=-2, EVEN(-3)=-4. It always increases the absolute value to the next even number. This maintains consistency with 'rounding up' in magnitude.
- What is the difference between EVEN and CEILING? EVEN always rounds to even integers. CEILING rounds to any multiple you specify. CEILING(3,2)=4 is similar to EVEN(3)=4, but CEILING is more flexible: CEILING(3,5)=5 rounds to nearest 5.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.