Rounds a positive number up to the next even integer and a negative number down to the next even integer.
Returns Number rounded to the next even integer up, away from zero.
Number is a real number or a reference to the cell containing that number whose even rounded up/down value is to be calculated.
|=EVEN(2.3)||rounds up 2.3 to the nearest even integer||4|
|=EVEN(2)||rounds up 2 to the nearest even integer||2|
|=EVEN(0)||rounds up 0 to the nearest even integer||0|
|=EVEN(-0.5)||rounds down -0.5 to the nearest even integer||-2|
|=EVEN(-5)||rounds down -5 to the nearest even integer||-6|
Related LibreOffice functions:
Equivalent Excel functions: