EVEN

EVEN(number)

Returns the number rounded up to the nearest even integer.

number

The number you want to round up.

REMARKS

* If "number" is not numeric, then #VALUE! is returned.
* If "number" is an even integer then no rounding occurs.
* Negative numbers are rounded down.
* You can use the ROUND function to round to a specified number of digits.
* You can use the ODD function to round up to the nearest odd number.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=EVEN(23.4) = 24
2	=EVEN(1) = 2
3	=EVEN(12.1) = 14
4	=EVEN(0) = 0
5	=EVEN(-1) = -2
6	=EVEN(-23.2) = -24
7	=EVEN(-23.9) = -24
8	=EVEN("-23.9") = -24
9	=EVEN("some text") = #VALUE!