EVEN(number)

Returns the number rounded up to the nearest even integer.

numberThe 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.office.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!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top