Excel EVEN Function

The Excel EVEN function returns number rounded up to the nearest even integer. The EVEN function always rounds away from zero, so positive numbers become larger and negative numbers become smaller. If number is an even integer, no rounding occurs.

The EVEN function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function in Excel. As a worksheet function, the EVEN function can be used as part of a formula in a worksheet cell.

Syntax

EVEN(number)

Parameters

Return Value

Returns number rounded up to the nearest even integer.

Notes

• If the argument is a non-numeric value, EVEN returns #VALUE! error.

Example: Using as Worksheet Function

The example below shows how to use the EVEN function as worksheet function.

Based on the Excel spreadsheet above, the output of the following worksheet formula will be:

=EVEN(B5)
Result: 2

=EVEN(B6)
Result: 2

=EVEN(B7)
Result: 2

=EVEN(B8)
Result: 0

=EVEN(B9)
Result: -2

=EVEN(B10)
Result: -2

=EVEN(B11)
Result: -2