EVEN takes just one argument, number, which should be a numeric value. With positive numbers, EVEN rounds number up to the next even integer. With negative values, EVEN rounds number down away from zero to the next negative integer. With zero (0) and numbers that are already even integers, number is unchanged.
Examples
The EVEN function rounds positive numbers up to the next even integer: Negative numbers are rounded away from zero to the next even integer: Zero and numbers that are already even integers are unaffected: To round numbers up to the next odd integer, see the ODD function.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
