Syntax
EVEN(number)
| Parameter | Description |
|---|---|
| number | Parameter of the EVEN function. |
Examples
Round up to even
Formula
=EVEN(3)
Returns 4. The next even integer above 3 is 4.
Already even
Formula
=EVEN(6)
Returns 6. If the number is already an even integer, it stays unchanged.
Negative number
Formula
=EVEN(-3.5)
Returns -4. For negative numbers, EVEN rounds away from zero to the next even integer.
Common Errors
#VALUE!
Non-numeric input like =EVEN("text") returns #VALUE!.
Tips
Pairing items
If you need to order items that come in pairs (shoes, gloves, bookends), =EVEN(quantity_needed) ensures you order an even number.
Combine with ODD
Use EVEN and ODD together to ensure values align to even or odd grids in engineering or layout calculations.
Rounds away from zero
EVEN(1.1) returns 2, EVEN(-1.1) returns -2. It always increases the absolute value to the next even integer.
Try EVEN in Viztab
Import your data and use EVEN with 370+ other formulas. No signup required.
Open Viztab