ISODD in WPS Spreadsheet: Audit Odd Values, Truncation and Alternating Groups

• Introduced: documented by 2019-05-30 in WPS material; the first release is not established.
• Availability: current WPS Windows documentation identifies the function as built-in; the historical lesson has a blank edition field.
• Scope: exact supported builds and other WPS clients remain unverified.
• Checked: October 14, 2026. Documentation and independent examples; no native WPS execution.

=ISODD(number)

The official lesson defines one required numeric argument, truncation for nonintegers and #VALUE! for nonnumeric arguments. Its walkthrough explicitly says to ignore digits after the decimal point before testing oddness.

That is a test of the truncated integer, not a promise that the original argument was itself an odd integer. Keep the original value beside the result whenever fractions would indicate bad input.

Enter only the numeric input column in A2:A7. Calculate B2 with =TRUNC(A2) and C2 with =ISODD(A2), then fill down.

The integer −5 is odd because it can be written as two times −3 plus one. Zero is even, so the zero row and the truncated −0.2 row both return FALSE.

The arithmetic model also makes the sign symmetry clear: ±5.8 both truncate to odd integers. Rounding to the nearest integer would instead produce ±6 and answer a different question.

For the same rows, calculate =INT(A2) in D2 and =ISODD(D2) in E2. The integers are −6, −5, −1, 0, 4 and 5, and the resulting odd tests are FALSE, TRUE, TRUE, FALSE, FALSE and TRUE.

WPS’s dedicated INT definition rounds downward, while TRUNC removes the fractional part. The examples follow those separate definitions. An imprecise comparison sentence in the older TRUNC page is not treated as an alternative INT rule.

This matters particularly for −0.2: ISODD tests its truncated zero, but ISODD after INT tests −1. Neither result alone says which input policy your worksheet should use.

Use a separate area. Enter 1, 2, 3.7, 5, −3 and −2.9 in G2:G7. Fill these three helper formulas down:

H2: =G2=TRUNC(G2)
I2: =ISODD(G2)
J2: =AND(H2,I2)

The destination labels H2, I2 and J2 are explanatory; enter only each formula after its label.

The accepted values are 1, 5 and −3. The fraction 3.7 shows why ISODD alone is insufficient for a whole-number requirement. If only positive record numbers are allowed, add a separate greater-than-zero control; the accepted values would then be 1 and 5.

Put =IF(J2,1,0) in K2 and fill down. The flags 1, 0, 0, 1, 1 and 0 total 3 with =SUM(K2:K7). Explicit numeric flags keep the count independent of implicit Boolean aggregation behavior.

In a fresh range M2:M7, enter the integers 1 through 6. Fill =IF(ISODD(M2),"Group A","Group B") down in N2:N7. Expected labels alternate Group A, Group B, Group A, Group B, Group A, Group B.

This is based on the sequence values, not on worksheet row numbers. If the row containing value two is deleted, the surviving value three remains Group A. If you need groups to alternate by their current visible position, maintain a deliberate position sequence rather than assuming stored identifiers will be consecutive after editing or filtering.

IF supplies the labels; ISEVEN provides the complementary test for the same ordinary numeric integer model. Both return logical results, not formatted text labels by themselves.

The source’s nonnumeric #VALUE! rule covers ordinary nonnumeric text. It does not establish every detail for numeric-looking text, logical values or empty references. Those cases are not borrowed from another spreadsheet product.

A numeric-type check and explicit source-cleaning step can keep a numeric validation workflow inspectable. The examples here use actual numbers, and their calculated outputs are not a claim of native execution. The historical fragment mentioning an unavailable function does not establish a required add-in; current Windows documentation identifies ISODD as built-in.

• WPS Academy: ISODD, 2019-05-30 (Chinese).
• Current WPS Windows ISODD introduction.
• WPS TRUNC definition and dedicated INT definition (Chinese).
• Editorial testing standards.

Complete function-specific sources reviewed. Worked results are independently derived expectations; no native WPS execution was performed. Formulas use English names and comma separators. Check the installed locale before entering them.