EVEN

EVEN(number)

Returns the number rounded to the nearest even integer.

number

The number you want to round up or down.

REMARKS

* Positive numbers are rounded up.
* Negative numbers are rounded down.
* If "number" is an even integer, then no rounding takes place.
* If "number" is not numeric, then #VALUE! is returned.
* 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.
* You can use the ISEVEN function to return the boolean True or False depending if the value is an even number.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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!