ODD in WPS Spreadsheet: Round Away From Zero to an Odd Integer
Use WPS ODD for signed odd-integer rounding, staffing thresholds and centered layouts, with clear zero-boundary limits.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: ODD rounds away from zero to an odd integer; existing odd integers remain unchanged. =ODD(4.2) has expected result 5, while =ODD(-4.2) gives −5.
Availability and version history
- 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.
Syntax and signed controls
=ODD(number)
The single argument is the value to round. The documented direction is away from zero, rather than always toward positive infinity. Examples use English function names and numeric inputs.
Enter −5, −4.2, −2, −0.1, 0.1, 2, 4.2 and 5 in A2:A9 and fill =ODD(A2) down the next column:
| Input | Expected result |
|---|---|
| −5 | −5 |
| −4.2 | −5 |
| −2 | −3 |
| −0.1 | −1 |
| 0.1 | 1 |
| 2 | 3 |
| 4.2 | 5 |
| 5 | 5 |
These are independently calculated expectations. The captured WPS lesson does not explicitly settle the zero-input direction, so native ODD(0) is not certified here. Neither the positive nor negative near-zero control should be silently substituted for exactly zero.
Example 2: require an odd count meeting a minimum
A group has 30 people and needs an odd number of participants that is at least half the group:
=ODD(30/2)
Expected minimum: 15. For a group of 32, =ODD(32/2) gives 17, since 16 is even. Groups of 31 and 33 both give 17 from their fractional half-size thresholds.
The WPS lesson uses this kind of participation example. An odd number can prevent a simple two-choice tie only under additional assumptions, such as every participant casting exactly one valid vote for one of two options. ODD alone cannot guarantee a decision when abstentions or more choices are allowed.
Advanced check: at least half is different from strictly more than half
For a group of 30, 15 is exactly half. If policy requires strictly more than half and an odd participant count, the preceding formula does not enforce it. For a positive integer group size in A2, first form the smallest integer strictly above half, then make it odd:
=ODD(INT(A2/2)+1)
At A2=30 the expected result is 17. At 32 it is also 17; at 34 it becomes 19. The INT step matters because it expresses the strict threshold before parity adjustment.
Validate whole, positive group sizes before applying this policy model. A rounding function is not a substitute for deciding which rule the organization actually requires.
Advanced example: create a centered layout with a middle position
A symmetrical row of markers needs at least 12 positions and must have a single center:
=ODD(12)
=(ODD(12)-1)/2
Expected results are 13 total positions and 6 on each side. One center plus six left and six right makes 13. If the minimum is already 13, the result remains 13; a minimum of 14 requires 15.
Here the desired odd count has a concrete meaning. Do not use ODD merely because a displayed number looks inconvenient; identify the target unit and the reason parity is required.
Advanced check: inspect boundary jumps
=ODD(4.99)
=ODD(5)
=ODD(5.01)
Expected results are 5, 5 and 7. The negative counterparts give −5, −5 and −7. Exactly reaching an odd integer leaves it unchanged; crossing it increases magnitude to the next odd integer.
For two separate minimum requirements of four positions each, =ODD(4)+ODD(4) gives 10. If a single pooled layout needs eight positions with one center, =ODD(4+4) instead gives 9. The location of the rounding operation changes the constraint being applied.
Troubleshooting and limits
The source documents #VALUE! for a nonnumeric argument, but a complete native text-number, blank, Boolean and error-conversion matrix is not established. The exactly-zero case and large-input precision remain unverified as well.
Keep stored inputs distinct from their formatted displays. A value shown as 5.00 might actually be slightly greater than five and therefore move to seven under the documented rule. Use EVEN when the target is an even integer; use ordinary decimal rounding functions when parity is irrelevant.
References and verification
- WPS Academy: ODD 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.