EVEN()
Syntax. EVEN(number)
Definition. This function rounds a number up to the nearest even integer.
Argument
number (required) The value to round to the nearest even number. If number isn’t a numeric expression, the EVEN() function returns the
#VALUE!error.
Background. Unlike ROUND(), the EVEN() function always rounds a number up to the nearest even integer. Regardless of the sign of number, a value is rounded up when adjusted based on zero. If number is an even integer, no rounding occurs.
All numbers that can be divided by two are even numbers. You can use this function for processing elements that come in pairs.
Examples. Two heirs want to calculate their inheritance. To simplify the calculation, all amounts have to be divisible by 2.
More examples ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
