EVEN in WPS Spreadsheet: Round Away From Zero to an Even Integer

• Introduced: documented by 2019-06-12 in the official WPS lesson; original introduction is not established.
• Availability: WPS Office for Windows Personal; no numeric release is stated in the edition metadata.
• Scope: exact current supported builds remain unverified. The Windows lesson does not establish equivalent availability in other WPS clients.
• Checked: October 14, 2026 against function-specific documentation. Examples were independently calculated; no native WPS test was performed.

=EVEN(number)

The argument is the number to round. The WPS lesson’s precise rule is increasing absolute magnitude until an even integer is reached. Its generic argument wording about rounding should not be read as a nearest-integer rule: negative inputs move toward a more negative value.

Examples use English function names and numeric inputs. Enter the following input column in A2:A10 and fill =EVEN(A2) down B2:B10:

Zero is even, so it follows the documented unchanged-even rule. Expected values are independently calculated; no native WPS execution is claimed.

A shipment contains 153 items, with two positions in every fully allocated pack:

=EVEN(153)
=EVEN(153)/2
=EVEN(153)-153

Expected results are 154 positions, 77 packs, and 1 unused position. The first agrees with the official WPS demonstration. EVEN itself returns a capacity rounded to an even count, not the number of packs; divide by two for that second quantity.

At 154 items the capacity remains 154 with no spare position. At 155 items the capacity becomes 156, requiring 78 packs. Validate that item counts are nonnegative integers before using this practical interpretation.

Two independent batches each contain three items:

=EVEN(3)+EVEN(3)
=EVEN(3+3)

Expected totals are 8 and 6 positions. The first rounds each batch separately to four positions. The second permits all six items to share paired capacity across batch boundaries.

Neither answer is universally correct. Decide whether batches can share a pack before choosing where to round. This is the same structural issue that can arise in monetary rounding, but here the unit is a pair of positions.

=EVEN(3.99)
=EVEN(4)
=EVEN(4.01)

Expected results are 4, 4 and 6. A tiny positive increase past an even integer crosses the entire next pair boundary. The signed controls −3.99, −4 and −4.01 give −4, −4 and −6.

A displayed value of 4.00 can conceal a stored value such as 4.001. In the documented mathematical model, =EVEN(4.001) gives 6. Formatting a cell to two decimals does not itself replace its stored value with four; inspect the actual input before diagnosing an unexpected result.

For a nonnegative x, paired capacity can be independently modeled as twice the integer ceiling of x/2. Using a separately documented rounding function:

=2*ROUNDUP(5/2,0)
=EVEN(5)

Both expected results are 6. This is a small control using ROUNDUP, not proof of identical behavior for every type, error or extreme value in all WPS clients.

The same physical capacity model should not be applied to a negative item count. =EVEN(-5) is mathematically expected to return −6, but negative inventory may represent a separate adjustment rather than a shipment requiring packs.

The source documents #VALUE! for a nonnumeric argument without enumerating every text-number, blank or Boolean conversion. Those conversions and large-input limits remain unverified. Keep actual numbers in the input cells and validate count rules separately.

For odd target integers use ODD. For a general decimal-place rounding operation, EVEN is the wrong tool: its defining target is an even integer, and it has no precision or arbitrary-multiple argument.

• WPS Academy: EVEN lesson, 2019-06-12 (Chinese; Windows Personal scope).
• Editorial testing standards.

The direct WPS product lesson supports the stated function scope. Worked outputs are independent expectations, not captured native results or proof of support across all current WPS clients.