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.