Excel EVEN function

Function              EVEN

Description        Excel EVEN function returns number rounded up to the nearest even integer.

Syntax  EVEN(number)

Angle    Mandatory. The value to be rounded up in even.

 

Example:

=EVEN(-23)=-24

=EVEN(23)=24

 

Usage Notes:

  • If number is nonnumeric, EVEN returns the error #VALUE!
  • For negative number it rounds up away from zero.