Excel: Even Function

In Excel, the Even function rounds a number up to the nearest even integer. If the number is negative, the number is rounded away from zero.

The syntax for the Even function is:

Even( number )

number is a numeric value.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Even(A1) would return 212

=Even(A2) would return 4

=Even(A3) would return -4

=Even(6) would return 6