EVEN

EVEN(number)

Returns the number rounded to the nearest even integer.

number

The number you want to round up or down.

REMARKS

* For an illustrated example refer to the Rounding Functions page.
* Positive numbers are rounded up.
* Negative numbers are rounded down.
* If "number" is an even integer, there will be no rounding.
* If "number" is not numeric, then #VALUE! is returned.
* You can use the ROUND function to round to a certain number of decimal places or 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

	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!

1 - What is the nearest even number to 23.4.
2 - What is the nearest even number to 1.
3 - What is the nearest even number to 12.1.
4 - What is the nearest even number to -1.
5 - What is the nearest even number to 0.
6 - What is the nearest even number to -23.4.
7 - What is the nearest even number to -23.9.
8 - What is the nearest even number to the text "-23.9".
9 - If number is not numeric.