EVEN

Rounds a number up to the nearest even integer to ensure results conform to even-number requirements in calculations.

The EVEN function rounds a number up to the nearest even integer. If the input number is already an even number, it remains unchanged. The function accepts numeric values as well as cell 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 input number to be rounded off (Required).

Example

EVEN(Column)

In the example below, the Even measure is created using the EVEN function, which returns the nearest even integer of the values in MEASURE 2.

Applying EVEN function

Excel equivalent

EVEN