EVEN

The EVEN function rounds a number up to the nearest even integer. If the input number is already even, it remains unchanged. The function accepts numeric values as well as node references as arguments. It is commonly used in calculations where results must conform to even-number requirements, such as packaging quantities, batch sizes, or standardized increments.

Syntax

EVEN(value)

Arguments

• value: The number or node reference to round to the nearest even integer.

Return value

Returns the nearest even integer greater than or equal to the specified value.

Example

EVEN(Planned Units)

In this example, the EVEN function is used to create the Even Planned Units measure, which returns the values in the Planned Units measure rounded up to the nearest even integer.

Excel equivalent

EVEN