| Formula Functions > Functions D to G > EVEN |
This function rounds the specified value up to the nearest even integer.
EVEN(value)
The argument can be any numeric value.
Regardless of the sign of the number specified by the argument, the number is rounded away from zero.
Accepts numeric data. Returns numeric data.
EVEN(A3)
EVEN(R1C2)
EVEN(5) gives the result 6
EVEN(-2.5) gives the result -4
This function is available in product version 1.0 or later.
CEILING | FLOOR | ODD | ISEVEN | Math and Trigonometry Functions