EVEN function in Excel returns the next even integer after rounding a given number up. Please note that EVEN function always rounds numbers up (away from zero)
- Positive number becomes more positive
- Negative number becomes more negative
Syntax of EVEN Function in Excel
EVEN (number)
Number is a numeric value that you want to round up to the nearest Even integer
Example of EVEN Function in Excel
Formula
- For value in Row number 2 when rounded up the nearest Even integer will be 4
- For Row number 3 the nearest rounded up even integer will be 2(moving away from zero)
- For Row number 4 the nearest rounded up even integer will be -2(moving away from zero)
So the result will be