EVEN Function in Excel – Round up to the nearest Even number in Excel

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

EVEN Function in Excel 1

  • 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

Result

EVEN Function in Excel 2

previous-small EVEN Function in Excel                                                                                                                next_small EVEN Function in Excel