EVEN

Returns the smallest even integer that is greater than or equal to the given number. For positive numbers, it rounds up; for negative numbers, it rounds away from zero to the next even integer.

Parameter List

Syntax
EVEN(number)
number

The numeric value to round to the nearest even integer. For example: 1.5, -2.3, A1, or any numeric expression.

More details

EVEN always rounds away from zero to the next even integer. For positive numbers, this means rounding up (e.g., 1.5 becomes 2). For negative numbers, this means rounding down (e.g., -1.5 becomes -2). If the number is already even, it returns the number unchanged.

Examples

EVEN() returns 1