ONLYOFFICE ISODD Function: Odd Number Tests and Examples
Test odd numbers, including negatives and fractional values, with ONLYOFFICE Spreadsheet Editor's ISODD function.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in ONLYOFFICE Spreadsheet Editor. How formula examples are checked
Quick answer: =ISODD(A2) returns the logical value TRUE when the numeric value in cell A2 is odd and FALSE when it is even. ONLYOFFICE documents that decimal inputs are truncated for this test. As a result, =ISODD(5.75) is expected to return TRUE, because the integer portion is 5. ISODD tests oddness; it does not round to an odd number.
Syntax and arguments
=ISODD(number)
| Argument | Required? | Definition |
|---|---|---|
number |
Yes | Number or cell reference to evaluate for oddness. |
The official function page specifies one required argument and returns TRUE or FALSE for numeric inputs. It also describes decimal truncation and #VALUE! for nonnumeric inputs. There is no optional argument and no documented missing-argument default. Numeric-looking text coercion and Boolean-to-number conversion are not established by the checked vendor page and require native tests.
Worked example: identify odd sequence numbers
Type these inputs in cells A2:A8. Enter the formula into B2 and fill down:
=ISODD(A2)
| Row | Input in A | Expected in B | Reason |
|---|---|---|---|
| 2 | 1 |
TRUE |
One is odd. |
| 3 | 2 |
FALSE |
Two is even. |
| 4 | 0 |
FALSE |
Zero is even. |
| 5 | -7 |
TRUE |
Negative seven is odd. |
| 6 | -8 |
FALSE |
Negative eight is even. |
| 7 | 5.75 |
TRUE |
Truncation produces 5. |
| 8 | -6.75 |
FALSE |
Truncation produces -6. |
Validation type: independent calculation. The outputs are expected by applying the documented truncation rule and integer parity, not observed from ONLYOFFICE software. An additional check =ISODD(-3.9) should produce TRUE because the evaluated integer is -3.
Applied example: label alternating whole-number records
If column A contains whole-number batch IDs, use:
=IF(ISODD(A2),"Odd batch","Even batch")
For A2 = 17 the expected output is Odd batch, and for A2 = 18 it is Even batch. The formula does not itself validate that the inputs are whole numbers or that identifier sequences are consecutive.
For quantities that must be whole integers, reject decimals before checking oddness:
=IF(A2=TRUNC(A2),IF(ISODD(A2),"Single item left over","All items paired"),"Correct fractional quantity")
For A2 = 5, the expected label is Single item left over. For A2 = 5.75, the expected label is Correct fractional quantity. This avoids treating truncated fractional quantities as valid whole-unit inventory. These examples use documented common IF/TRUNC semantics; run them on the actual deployment editor before relying on them.
Troubleshooting and edge cases
| Symptom | Explanation | Action |
|---|---|---|
#VALUE! |
Nonnumeric input | Inspect and clean the referenced cell. |
5.75 returns TRUE |
The decimal is truncated | Check A2=TRUNC(A2) for integer-only data. |
-6.75 returns FALSE |
The truncated value is -6, which is even | Do not confuse truncation with INT (floor). |
| A zero is not odd | Zero is divisible by two | Expect FALSE. |
| Identifier text is not handled as expected | Numeric-looking text coercion is unverified | Verify source type and test in the target ONLYOFFICE edition. |
| A copied formula tests the wrong row | Mixed/absolute references | Check A2, A3, A4 cell references after filling. |
Based on the official documentation, =ISODD("unknown") should produce #VALUE!. Do not infer error handling for every text-to-number conversion from this one nonnumeric case.
ISODD, ODD, ISEVEN, and MOD: different jobs
ISODD and ISEVEN are logical tests. ODD is a numeric rounding function, not an oddness test: a value passed to ODD may change magnitude, whereas ISODD returns TRUE or FALSE. MOD(A2,2) may help audit parity when input is a validated integer, but its sign conventions and coercions must not be assumed identical to ISODD’s without testing.
A parity test is useful for alternating record formats or paired physical quantities. It does not guarantee validity of dates, nonnumeric codes, or business inventory rules; such constraints should be checked separately.
Version, editor and locale compatibility
The checked English-language ONLYOFFICE documentation confirms ISODD’s documented syntax but does not identify the exact first supporting release, every editor edition, or localized function spellings and separator settings. The official Formula tab guide discusses web and desktop formula interfaces but is not a validated version matrix. The sample formulas use the English function name and conventional argument commas in compound formulas; some locales may require different separators. No cross-software parity claim has been made beyond descriptions of closely related functions.
Official sources and verification status
- ONLYOFFICE ISODD reference — documented purpose, argument, decimals, results and error. Checked 2026-10-13 UTC.
- ONLYOFFICE function list — documented presence in the Information category. Checked 2026-10-13 UTC.
- ONLYOFFICE Formula tab — general desktop/web interface reference. Checked 2026-10-13 UTC.
Verification limits: Official rules and every displayed example were independently checked. No native ONLYOFFICE execution or localized formula test was performed. Historical release support, undocumented coercion and any array/date-system boundaries noted above remain untested.