EVEN in Excel: Round Away from Zero to an Even Integer

• Introduced: First introduction version is not established by the official history reviewed.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Checked: October 14, 2026; official EVEN reference. Documentation and independently calculated examples; no native Excel execution or broader platform certification.

=EVEN(number)

The single argument is required. Microsoft states that the adjustment is away from zero regardless of sign; an already even integer is unchanged. A nonnumeric argument produces #VALUE! according to the dedicated reference.

The function rounds to a parity class, not to a chosen decimal precision. EVEN(5.2) does not mean keep two decimal places. Use ROUND when the actual requirement concerns decimal digits and a nearest-value rounding policy.

Enter −5.2, −4, −0.2, 0, 0.2, 4, 5.2 in A2:A8. Fill =EVEN(A2) down.

Expected results are −6, −4, −2, 0, 2, 4, 6. Zero is already an even integer under the unchanged-even rule. The small negative input becomes −2 rather than zero because the adjustment is away from zero.

The pair −4 and 4 verifies that an exact boundary does not receive an extra increment. Rounding away from zero is only required when the source value is not already an allowed even integer.

For the input −3, EVEN gives −4. A rule selecting the least even integer greater than or equal to −3 would instead choose −2. These are different signed operations.

Write the intended sentence before selecting a function. A report using positive quantities alone may hide the difference because several rounding rules agree for that restricted input range.

A fictional display requires one position per item, but positions can be added only in pairs. Enter item counts 0, 1, 2, 3, 7 in D2:D6 and use:

=EVEN(D2)

Expected available capacities are 0, 2, 2, 4, 8. The corresponding spare positions, calculated as capacity minus item count, are 0, 1, 0, 1, 1.

The number of purchased pairs is capacity divided by two: 0, 1, 1, 2, 4. Capacity and pair count are different units. The model assumes nonnegative whole item counts; a negative quantity is outside this physical interpretation even though EVEN has a defined signed calculation.

For ordinary finite inputs, applying EVEN again to an even result changes nothing. At 5.2:

=EVEN(5.2)
=EVEN(EVEN(5.2))

Both expected results are 6. By contrast, applying it separately to two fractional requirements can change the total: EVEN(1.1)+EVEN(1.1)=4, whereas EVEN(1.1+1.1)=4 here. Use a more revealing control of 2.1 and 2.1: separate rounding gives 8, while rounding the total 4.2 gives 6.

Specify whether each requirement needs its own paired capacity or whether they share one pool. The aggregation policy, not just the formula syntax, determines the appropriate total.

Check sign, parity, model units and rounding stage. An even-looking display is not proof that the stored value is an exact even integer. The controls above are independent mathematical expectations from the documented rule; they do not certify every binary boundary, huge input or imported-text conversion.

ODD selects odd integers instead. Changing between EVEN and ODD changes the permitted outputs, so it is not a harmless formatting adjustment.

• Microsoft EVEN reference.
• Editorial testing standards.

Worked inputs are fictional. Decimal answers are independently calculated mathematical expectations rounded to nine places, not captured native results. Extreme magnitudes, complete coercion matrices and cross-version numerical accuracy remain untested.