EVEN

Excel Functions

Round a number up to the next even integer

Syntax

EXCEL

=EVEN(number)

Arguments

Parameter	Description
`number`	The number to round up to an even integer.

Return Value

An even integer.

Details

The EVEN function rounds numbers up to the next even integer. EVEN always rounds numbers away from zero, so positive numbers become larger and negative numbers become smaller (i.e. more negative). 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. 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:

Examples

The EVEN function rounds positive numbers up to the next even integer:

EXCEL

=EVEN(1) // returns 2
=EVEN(3.1) // returns 4

Examples

Negative numbers are rounded away from zero to the next even integer:

EXCEL

=EVEN(-1) // returns -2
=EVEN(-3.1) // returns -4

Examples

Zero and numbers that are already even integers are unaffected:

EXCEL

=EVEN(2) // returns 2
=EVEN(0) // returns 0
=EVEN(-2) // returns -2

EVEN

Syntax

Arguments

Return Value

Details

Examples

See Also