Excel EVEN Function

Function Description

The Excel Even function rounds a supplied number away from zero (i.e. rounds a positive number up and a negative number down), to the next even number.

The syntax of the function is:

EVEN( number )

Where the number argument is the numeric value that you want to round.


Even Function Examples

The following spreadsheet shows several examples of the Excel Even function:

 Formulas:
 AB
1 =EVEN( 23 )
22.22=EVEN( A2 )
3 =EVEN( A2 + 4 )
40=EVEN( A4 )
5-0.3=EVEN( A5 )
6-11=EVEN( A6 )
7-4=EVEN( A7 )
 Results:
 AB
1 24
22.224
3 8
400
5-0.3-2
6-11-12
7-4-4

The above examples show how the Even function always rounds away from zero. I.e. If the supplied number is positive, it is rounded up (more positive), but if the supplied number is negative, it is rounded down (more negative).


For further details on the Excel Even Function, see the Microsoft Office website. Or, for a comparison of the Excel Rounding Functions, see the Excel Rounding Functions page.