The EVEN function rounds a number away from zero to the next even number.
EVEN(num-to-round)
num-to-round: The number value to be rounded.
Examples |
|---|
=EVEN(1) returns 2, the nearest even number going away from zero. =EVEN(2) returns 2, because 2 is an even number. =EVEN(2.5) returns 4, the nearest even number going away from zero. =EVEN(-2.5) returns -4, the nearest even number going away from zero. =EVEN(0) returns 0, because 0 is considered to be an even number. |