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 for this function are:

• =EVEN(4.5) returns 6.

• =EVEN(-6.3) returns -8.

• =EVEN(59959) returns 59,960.

See Also

CEILING(), CEILING.PRECISE(), FLOOR(), FLOOR.PRECISE(), INT(), ISEVEN(), ISODD(), ODD(), ROUND(), TRUNC()

Sample Files

Use the ROUND worksheet in the Chapter16.xls or Chapter16.xlsx sample file. The sample files are found in the Chapter16 folder. For more information about the sample files, see the section titled Using the Sample Files.