The even function rounds a positive numerical value up to the nearest even integer (whole number), and rounds negative numerical values down to the nearest even integer.
Syntax
= EVEN([number])number = the value or input that is to be rounded. Can be a cell reference or a hardcoded value.
Explanation
This function is categorized as a "Math and Trigonometry", and its primary purpose is to round a given value to the nearest even integer (an integer being a whole number without any decimals i.e. 3, 6, 225...) . This function always rounds away from zero, meaning a positive value with be rounded up, and a negative value will be rounded down. It's also worth noting 0 will remain 0.
*All input values will follow the rules set in the table above.
Examples
1. Round Positive Integers and Decimals to the Nearest Even Integer
The EVEN function makes it very easy to round any input up to the nearest even integer to fit your needs.
2. Round Negative Integers and Decimals to the Nearest Even Integer
The same can be done for negative numbers, but instead rounding down to the nearest even integer.
